Why does VS not support Sql Server 2000?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Jason Stonebraker (stonebrj_at_bellsouth.net)
Date: 02/10/04 

Date: Tue, 10 Feb 2004 00:56:40 -0500

I am following the instructions for creating a simple web forms page that
reads data from a database and displays it in a datagrid. While creating
the SqlConnection in the Data Link Properties dialog box I receive an error
at two different points in the process. The first comes when attempting to
select a server name from the drop down box. The error reads, "Error
enumerating data servers. Enumerator reports 'Unspecified error'". No
servers are listed in the drop down boxe's list. So I type in "(local)" and
move on, entering my username and password to the local sql server (2000
developer edition with sp3a), and then selecting the database from the
database drop down list. I press the "Test Connection" button and the
connection succeeds. However, when I press OK to exit the dialog box I
receive this error, "Unable to connect to database. It is only possible to
connect to SQLServer Desktop Engine databases and Microsoft Access databases
with this version of Visual Studio." Does this mean that Visual Basic .Net
does not support SQL Server 200 databases? I have followed the instructions
for installing MSDE, but the installer did not recognize my fully
functioning default instance of Sql Server. Does anyone know how to remedy
this. Data access is the main reason for using this IDE. I am using Visual
Basic .Net 2003.

Sorry for the long message...

Thank you in advance,
Jason

Quantcast