May 16, 2011 at 12:39 pm
When i run the below qry..
SELECT top 10 empid,empno,jdate FROM OBBEAVER.Rev_Staff.dbo.employee
I get this error
Msg 7313, Level 16, State 1, Line 2
An invalid schema or catalog was specified for the provider "SQLNCLI" for linked server "OBBEAVER".
and when i run the same query on a different database of the same remote server i dont have any issues, which means my link server is working fine. So what might be the problem ot kick off this error
May 16, 2011 at 1:01 pm
Tara-1044200 (5/16/2011)
When i run the below qry..SELECT top 10 empid,empno,jdate FROM OBBEAVER.Rev_Staff.dbo.employee
I get this error
Msg 7313, Level 16, State 1, Line 2
An invalid schema or catalog was specified for the provider "SQLNCLI" for linked server "OBBEAVER".
It sounds as if it is an issue with the Data Source Names.
http://www.ideaexcursion.com/2009/02/25/howto-setup-sql-server-linked-server-to-mysql/
For better, quicker answers on T-SQL questions, click on the following...
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 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply