Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Linked Server problem Expand / Collapse
Author
Message
Posted Monday, January 07, 2008 11:45 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 4:42 AM
Points: 193, Visits: 541
I have setup a linked server from a SQL 2000 Standard Edition, 8.00.760 (SP3) to a SQL 2005 Standard Edition 64-bit 9.00.2047.00 and used "Microsoft OLE DB Provider for SQL Server".
It could work fine on all databases but except one :

Server: Msg 7313, Level 16, State 1, Line 1
Invalid schema or catalog specified for provider 'SQLOLEDB'.
OLE DB error trace [Non-interface error: Invalid schema or catalog specified for the provider.].

The linked server worked fine and no problem on the other databases of the same server.
But always got the above error when I connected to one of my database.

Post #439890
Posted Wednesday, January 09, 2008 8:11 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, October 07, 2008 11:53 AM
Points: 46, Visits: 85
You may need to check out the instcat.sql

Is your SQL Server 2000 instance running SP4?

If not, in order for Distributed queries in SQL Server 2005 to work against SQL Server 2000, you need to run the instcat.sql script that is supplied as part of SP4 on your SQL Server 2000 instance.

If you are not running SP4 on sql server 2000, you should upgrade it.
Post #440689
Posted Wednesday, January 09, 2008 6:41 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 4:42 AM
Points: 193, Visits: 541
I fixed the problem by myself.
The cause was : there is a space character at the end of the database name, for example, the db name should be "ABC", but its name is : "ABC " (typing mistake, of course).
That is the reason why the Linked Server is OK for the other databases but not it.
Post #440962
Posted Wednesday, January 09, 2008 10:36 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, November 02, 2011 9:50 PM
Points: 189, Visits: 335
You might still have a problem.

http://support.microsoft.com/default.aspx?scid=kb;en-us;906954

The steps detailed in here is bad as is reverting code Master database to that of SQL2000 SP3-4. Fun enough it only applies to


• Microsoft SQL Server 2005 Standard X64 Edition
• Microsoft SQL Server 2005 Developer Edition

CodeOn :P
Post #441003
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse