SQL 2K5 AND VS.NET 2K3

18 Feb 2006 8:39 PM

Chris

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

19 Feb 2006 1:24 AM

David R

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.

--
David R

Show quote

"Chris" wrote:

> 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

20 Feb 2006 4:58 PM

William (Bill) Vaughn

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.
__________________________________

Show quote

"Chris" <Ch***@discussions.microsoft.com> wrote in message
news:E9EA55C7-ECA9-4694-B7B3-45C085F3EA8F@microsoft.com...
> 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