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.
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
Posted: Visual C# Express Edition, Connecting visually with SQL SERVER 2000. C #2005 Express Edition Beta 2
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.
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