Showing posts with label bit. Show all posts
Showing posts with label bit. Show all posts

Friday, March 30, 2012

How to verify if 64 bit client tools are installed

Hi,

I would like to know how can I determine if I'm properly using 64 bit client tools for SQL Server? I have just installed SQL Server 2005 64 bit and I can see on the Add/Remove Program "Microsoft SQL Server 2005 (64-bit)". However, when I open SQL Server Management Studio or Business Intelligence Development Studio, I see the following on the Task Manager:

SqlWb.exe*32

devenv.exe*32

Thanks,

May Lanie

The client tools are 32bit. There are no 64bit Client tools publically available.

Friday, March 23, 2012

How to use SQLDataSource

Hello guys i am a bit confused, because i cannot do a simple select using the SQLDataSource from ASP.NET 2.0

here is how was doing after droping the SQLDatAdapter using the VS2003

Example

SqlDataAdapter1.SelectCommand="select * from users"

SQLDataAdapter1.Fill(Datasource1,"users")

TextBox1.DataBind()

my question is how to do it in VS2005 since that i dont see theDataAdapter anywhere, do i have to do by hand like declaring everything??

thank you in advance!!

Hi,

Because we are no longer have MSTray in the webform designer, we won't support SQLDataAdapter/DataSet on the designer. However, you can still use the old binding syntax with sqlDataAdapter/DataSet in the code.
For more information about new feature SQLDataSource, please seehttp://www.asp.net/Tutorials/quickstart.aspx

Hope that helps,

Lan

sql