VS2010 Using SQL Server 2000

Question

Is there a way to use the SQL Model Builder (dbml) in VS2010 using SQLServer2000? It works fine in VSExpress2008 + VS2008, but it generates the "SQL-2005 Update" error in VS2010, which seems a bit unreasonable.

Answer 1

The read here (Goto SQL Server 2000 Support ) at the bottom of the database is very limited for LINQ-SQL, which means you will have to consider upgrading if you want to use LINQ-SQL

Answer 2

Here are a few options:

• Create a 2008 project designed solely to update a DBML file. Go to this project when you want to manipulate the DBML file using the constructor.

• Update DBML directly (ick!).

Answer 3

I had the same problem and I was able to overcome it by creating a DBML file in VS2008 and then just copying it to the VS2010 project.

At first I tried to create it using SQLmetal from the VS2010 prompt, but the connection information is not saved, but of course you cannot add the connection from the dbml editor, since it does not connect to SQL2000.

Hope this helps.

Answer 4

I also had this problem when I tried to add a data connection through the server explorer in VS 2010 - it says that it only supports connections to MS SQL 2005 or higher. I was able to connect it to SQL Server 2000 db, adding a connection, selecting and selecting ".NET Framework Data Provider for OLE DB" as the data source, and for the OLE DB ddl provider, selecting "Native SQL Client", then enter the server on which db resides, security and db name.