?
Solved

Error from SQL Server 2005 to SQL Server 2000 Linked Server

Posted on 2007-08-08
5
Medium Priority
?
501 Views
Last Modified: 2013-11-05
I'm getting the below error message on a Linked Server between a SQL Server 2005 64-bit installation and a SQL Server 2000 installation.

What do I did to do to fix this? I've come across this:

http://msdn2.microsoft.com/en-US/library/aa215459(SQL.80).aspx

and this:

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

Does that mean I just need to run:

ISQL -Usa -Ppassword -S -iD:\Instcat.sql

and that will fix the issue up? I've noticed that I can't seem to run INstcat.sql becuase it fails to parse correctly.


****************

OLE DB provider "SQLNCLI" for linked server "LinkedServerNameRemoved" returned message "Unspecified error".
OLE DB provider "SQLNCLI" for linked server "LinkedServerNameRemoved" returned message "The stored procedure required to complete this operation could not be found on the server. Please contact your system administrator.".
Msg 7311, Level 16, State 2, Line 1
Cannot obtain the schema rowset "DBSCHEMA_TABLES_INFO" for OLE DB provider "SQLNCLI" for linked server "LinkedServerNameRemoved". The provider supports the interface, but returns a failure code when it is used.


****************
0
Comment
Question by:PeterErhard
  • 3
  • 2
5 Comments
 
LVL 12

Accepted Solution

by:
patrikt earned 2000 total points
ID: 19660645
First ensure that you have SP4 on your 2000 machine. Then locate instcat.sql script in SP4 installation (should be C:\Program Files\Microsoft SQL Server\MSSQL\Install by default).
Than run this script: ISQL -Usa -Ppassword -S<server2000SP4name> -i<location>\Instcat.sql

Some errors when running this?
0
 

Author Comment

by:PeterErhard
ID: 19660818
This machine has SP3a and has to stay with SP3a as the application doesn't support SP4.
0
 
LVL 12

Expert Comment

by:patrikt
ID: 19661157
No problem SP3 is enough. Could you locate Instcat.sql on it?
0
 

Author Comment

by:PeterErhard
ID: 19661234
No I can't actually.

Do you know where I can get instcat.sql for SP3?
0
 
LVL 12

Expert Comment

by:patrikt
ID: 19668121
Sorry, I don't understand. Have you solved the problem? If not why you accept my answer?
You could  not find instcat.sql in C:\Program Files\Microsoft SQL Server\MSSQL\Install?
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ready to get certified? Check out some courses that help you prepare for third-party exams.
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Suggested Courses

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question