SQL2012 is installed on Windows Server 2008 R2. I wanted to install SQL Server Native Drives 10.0 X86 version so that I can create linked server to SQL2000 box. But I am not able to install the native driver (SQLNCLI.msi). The erros is that it is not compatible to Windows Server 200 R2. Is there a workaround for these guys? Any help is appreciated.
When I try to create SYSTEM DSN for ODBC connection, I get this error: system DSN for ODBC error connect failed SQLSTATE '01000' SQL SERVER ERROR: 11001[MICROSOFT][ODBC SQL SERVER DRIVER][TCP/IP SOCKETS]ConnectionOpen (Connect()). Connection failed: SQLState '08001' SQL Server Error: 6 [MICROSOFT][ODBC SQL SERVER DRIVER][TCP/IP Sockets]Specified SQL Server not found
If it's not compatible then use another driver, like OLEDB or ODBC. SQL Server 2000 has passed end-of-life support, so current and future drivers won't support it.
Even if DSNs can be used for linked servers, there's no need for them and zero benefit. Learn to write proper connection strings, it's pretty easy:
Linked Server SQL2012 to SQL2000
Posted - 03/15/2013 : 13:56:32
