November 27, 2012 at 10:10 pm
I'm having an issue with a linked server I've created that points to a SQL 2000 instance.
I've created it ok by using the SQL Server Native Client 10.0 provider but I'm unable to browse the databases that should be viewable.
If I run a select against the linked server I get the following error:
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "SQLNCLI10" for linked server "<LINKEDSERVER>" reported an error. The provider did not give any information about the error.
Msg 7330, Level 16, State 2, Line 1
Cannot fetch a row from OLE DB provider "SQLNCLI10" for linked server "<LINKEDSERVER>".
Has anyone come across this?
I'm stumped!
November 28, 2012 at 2:31 am
Check the fallowing URL. I know that it is for SQLNCLI and not SQLNCLI10, but I've seen few references to this page by people that had this problem when they used SQLNCLI10 and they claimed that it help them solve this problem.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 28, 2012 at 3:00 pm
Thanks Adi.
Are you able to provide the link?
November 29, 2012 at 3:33 am
Chris-475469 (11/28/2012)
Thanks Adi.Are you able to provide the link?
I apologize, I don't know how I didn't notice that I didn't paste the URL into the message. Glad that you did manage to solve the problem.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply