SQL 2000 Not Supported by .NET Framework Data Provider for SQL Server in VS2010's Server Explorer D

Posted by Canoehead on Stack Overflow See other posts from Stack Overflow or by Canoehead
Published on 2010-04-29T14:02:21Z Indexed on 2010/04/29 14:07 UTC
Read the original article Hit count: 574

Filed under:

sql-server

|

visual-studio-2010

|

.NET

|

dataprovider

Just tried creating a data connection to a SQL 2000 database in VS2010's Server Explorer using a .NET Framework Data Provider for SQL Server (versus OLE) and found that it didn't work.

VS2010 complained that I had to use SQL Server 2005 and up.

This used to work in VS2008 (using .NET Framework Data Provider for SQL Server instead of the .NET Framework Data Provider for OLE DB).

Is this just a VS2010 restriction or has the ability to connect to SQL 2000 with .NET Framework Data Provider for SQL Server been obsoleted in a post-2.0 version of .NET being used by VS2010?

Anyone know why this was done by MS (please don't speculate - I can do that myself ;>)?

© Stack Overflow or respective owner

Related posts about sql-server

SQL SERVER – Beginning SQL Server: One Step at a Time – SQL Server Magazine

as seen on SQL Authority - Search for 'SQL Authority'
I am glad to announce that along with SQLAuthority.com, I will be blogging on the prominent site of SQL Server Magazine. My very first blog post there is already live; read here: Beginning SQL Server: One Step at a Time. My association with SQL Server Magazine has been quite long, I have written nearly… >>> More
How to install SQL Server 2005 Configuration Manager without installing SQL Server Management Studio

as seen on Server Fault - Search for 'Server Fault'
Hi, I need to configure SQL Server aliases on a public-facing production server. To do that, I need to install SQL Server Configuration Manager. I was not able to find a standalone installer for that, so I am having to install SQL Server 2005 Client Components. This approach is not ideal as we don't… >>> More
[MAJ] SQL Server 2005 Express Edition - La version gratuite de SQL Server 2005

as seen on ASP-PHP.net - Search for 'ASP-PHP.net'
Modification technique pour le site de l'article. >>> More
How to create SQL Server Express DB from SQL Server DB

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a SQL Server 2008 DB. I want to extract SOME tables (and associated schema, constraints, indexes, etc) and create a SQL Server Express DB. It isn't a sync of the target, we stomp on it. We ONLY need to do this in the file system (not across the wire). We are not fond of the synchronization… >>> More
sql server 2000 error, error trying to connect to sql server 2005

as seen on Stack Overflow - Search for 'Stack Overflow'
i am connecting to sql server 2000 on a remote computer with a dotnet application, but when i try to open the connection it gives the following error: When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections What… >>> More

Related posts about visual-studio-2010

La version gratuite de Visual Studio 2010 est disponible, Visual Studio 2010 Express introduit des o

as seen on Developper.com - Search for 'Developper.com'
Visual Studio 2010 Express est disponible La version gratuite de Visual Studio 2010 propose à présent des outils de développement pour Windows Phone 7 Alors que Visual Studio 2010 débarque avec ses nouveautés (lire par ailleurs ici), sa version gratuite Visual Studio Express 2010 vient d'être… >>> More
Are Visual Studio 2010 Professional Solutions/Projects 100% compatible with Visual Studio 2010 Premi

as seen on Stack Overflow - Search for 'Stack Overflow'
I am just wondering on what version of Visual Studio 2010 to install (Professional or Premium) If there are a few people in the team with a mix of VS2010 professional/premium, would opening solution/project files be an issue, ie incorrect version or prompts to upgrade prjects.. Projects include:… >>> More
[ASP.NET 4.0] Persisting Row Selection in Data Controls

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
Data Control Selection Feature In ASP.NET 2.0: ASP.NET Data Controls row selection feature was based on row index (in the current page), this of course produce an issue if you try to select an item in the first page then navigate to the second page without select any record you will find the same… >>> More
Entity Framework Code-First to Provide Replacement for ASP.NET Profile Provider

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
A while back, I coordinated a project to add support for the SQL Table Profile Provider in ASP.NET 4 Web Applications. We urged Microsoft to improve ASP.NET’s built-in Profile support so our workaround wouldn’t be necessary. Instead, Microsoft plans to provide a replacement for ASP.NET Profile… >>> More
Tip#102: Did you know… How to specify tag specific formatting

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
Let’s see this with an example. I have the following html code on my page. Now if I format the document by selecting Edit –> Format document (or Ctrl K, Ctrl D) The document becomes I want the content inside td should remain on the same line Read More......(read more) >>> More