SQL 2K5 AND VS.NET 2K3

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to use VS.NET 2k3 to access SQL Server 2k5? Do you need any
special data access provider or will the built in provider work?

Thanks
 
Yes. The regular OLE DB Provider for SQLServer appears to work fine,
although if the SQL Native Client is installed with the SQL2k5 tools (as on
my machine), then SQL Native Client will show up as an option in VS2k3, and
could be used as well.
 
The SQL Native Client (via OLE DB) is designed to expose all of SS 2K5's
functionality. While the old OLE DB provider might work, it's not
recommended for a litany of reasons. I would also expect a normal SqlClient
connection to work as well, but not expose all of the new features.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Back
Top