Connecting SQL server 2000 using Visual Studio 201

2019-08-28 21:22发布

问题:

I'm facing following issue using Visual Studio 2012 when I'm trying to connect with MS SQL Server 2000 (in Data Connections window):

Strange is that it's actually getting list of databases when I'm using Microsoft SQL Server (SqlClient) as a data source.

Is there any way to connect VS 2012 and SQL Server 2000? Should I use different driver/provider? Is it possible at all to use those technologies together?

回答1:

I figured out the solution. .NET Framework Data Provder for OLE DB -> Microsoft OLE DB Provider for SQL must be used.