SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Linked Server SQL2012 to SQL2000
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

SQLNOVICE999
Yak Posting Veteran

57 Posts

Posted - 03/15/2013 :  13:56:32  Show Profile  Reply with Quote
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

57 Posts

Posted - 03/15/2013 :  16:21:42  Show Profile  Reply with Quote
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
Go to Top of Page

robvolk
Most Valuable Yak

USA
15683 Posts

Posted - 03/15/2013 :  16:35:41  Show Profile  Visit robvolk's Homepage  Reply with Quote
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/
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000