Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SQLNOVICE999
Yak Posting Veteran
62 Posts |
 Posted - 2013-03-15 : 13:56:32
|
| Hi Guys,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.Thanks,Laura |
|
|
SQLNOVICE999
Yak Posting Veteran
62 Posts |
Posted - 2013-03-15 : 16:21:42
|
| 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 |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2013-03-15 : 16:35:41
|
| 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:http://www.connectionstrings.com/ |
|
|
|
|
|
|
Linked Server SQL2012 to SQL2000