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