Clever Geek Handbook

How does ADO.Net know which version of SQL SQL client to use if you have SQL 2005 and 2008 in your environment?

How does ADO.Net know which version of Native Client SQL to use if you have SQL 2005 and 2008 in your environment?

+1


source to share


1 answer


They are backward compatible for the underlying services, so you don't even need to worry about that: if you have a native 2008 client installed, it must transparently connect to the 2005 or 2008 databases.

The only problem you're running into is parts like DTS or SQL-DMO, which seem to require a separate download for backward compatibility:

http://www.microsoft.com/downloads/details.aspx?FamilyId=C6C3E9EF-BA29-4A43-8D69-A2BED18FE73C&displaylang=en



Installing these will mean you don't have to worry about a native 2005 client on the system.

Does it help?

+3


source






More articles:


All Articles