January 7, 2008 at 11:45 pm
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.
January 9, 2008 at 8:11 am
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.
January 9, 2008 at 6:41 pm
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.
January 9, 2008 at 10:36 pm
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 😛
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply