problem connecting to the database

Hi...

I just started to go through the "Microsoft visual c# 2005 step by step" I noticed on page 412 when i try to connect to the database, it says tochoose "Microsoft SQL server" from the Choose datasource menu. But I dont have Microsoft SQL Server. There are only "Microsoft Access Database file" and "Microsoft SQL Server Database File" and not "Microsoft SQL Server".

Please Help

Sunil

Hi,

Do you have the MDAC 2.6 or later installed?

Regards,

Janos

|||Unless you choose to install SQL Server (download the free SQL Server 2005 Express here), you will have to use the Access file connection process.|||

thanks for the reply Janos... I'm fairly new to the SQL stuff... What is MDAC?

Thanks

Sunil

|||

thanks for the reply arnie.... yes i did install the free sql server 2005 express.... i still cant figure it out... i used the commands at the dos prompt to configure the SQL server like it says in the book and everything was good...

then i used sqlcmd -S yourserver\SQLExpress - E -iinstnwnd.sql

That was also successfull....

still i dont see "microsoft SQL server" in the choose datasource section. But i do see "Microsoft SQL server database file".

Thank you

|||

Hi,

Please follow Arnie Rowland's post. You should have SQL Server installed.

Regards,

Janos

|||Seems that you are using Visual Studio Express. If so, the behaviour is by design.

http://msdn2.microsoft.com/en-us/vstudio/aa700921.aspx

But you can code against it.

Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||

i'm sorry..i dont follow...what does it mean by design?

thank u

sunil

|||VS Express is not able to connect to SQL Server Express in the GUI (locked down feature) but you can programmtically access the Server.

Jens K. Suessmeyer.

http://www.sqlserver2005.de