Browsing SQL 2012 Databases

[visualsi]

Hi,

We have an installer that lists SQL Server instances, lets the user select one, then lists the databases for that instance and lets the user select one. For SQL Server 2012 instances, they get listed in the first screen, but if they are chosen on the second screen, it times out (we are using the 9.2 version of AI).

We are using the "SQL Server Native Client 10.0" to connect (When we used the "SQL Client", the second screen in the series sometimes listed the databases and other times it didn't. With the "SQL Server Native Client 10.0" it consistently lists all the databases in the instance.

I understand that the "SQL Server Native Client 10.0" came out before SQL Server 12, but SQL Server 12 has been out for a while and customers are expecting us to support it. Is there another official way to support them or a non-standard-but-it-works method for supporting SQL 2012?

Many thanks,
Rob

[mihai.petcu]

Hi Rob,

SQL Server Native Client 10 is used to connect to SQL Server 2008 whereas SQL Server Native Client 11 is used to connect to SQL Server 2012.
SQL Server Native Client 10 works with SQL Server 2012 because of backwards compatibility but you should use 11 instead.

All the best,
Mihai