Connecting visually with SQL SERVER 2000. C #2005 Express Edition Beta 2  
Author Message
VicIbar





PostPosted: Visual C# Express Edition, Connecting visually with SQL SERVER 2000. C #2005 Express Edition Beta 2 Top

Hello.

How can I connect to SQL SERVER 2000 visually from C# 2005 Express Edition Beta 2 The options that display the DataSource wizard not include SQL SERVER 2000, or other servers. I just see options for select .MDFs files, but no instances of SQL SEVERS installed in local machine.

I have intented by selecting Northwind.mdf file, but the connection fails.

Thanks.


Visual Studio Express Editions7  
 
 
Daniel Rieck





PostPosted: Visual C# Express Edition, Connecting visually with SQL SERVER 2000. C #2005 Express Edition Beta 2 Top

The Express editions are limited in which data sources you can use with the designers. You can access SQL Server 2000, but you will have to code it yourself.

 
 
Glenn Wilson





PostPosted: Visual C# Express Edition, Connecting visually with SQL SERVER 2000. C #2005 Express Edition Beta 2 Top

That is correct the Language based Express products can only connect using the internal wizards to the local SQL Express Database, an Access Database, an existing Webservice, or a built in object or class. For the Visual Web developer you can connect to remote datasources.

Visual Studio 2005 Product Line Overview
http://msdn.microsoft.com/vstudio/products/compare/default.aspx


 
 
Coleby





PostPosted: Visual C# Express Edition, Connecting visually with SQL SERVER 2000. C #2005 Express Edition Beta 2 Top

Hi, unfortunatly I'm not experienced enough at finding a work around for this. Would you point me in the direction of where I can find the code to create the class to connect to the sql db

thx