Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have a MSSQL2008 and MSSQL2005 in my system.All SP's is up-to-date.

2008;

Microsoft SQL Server 2008 (SP2) - 10.0.4000.0 (X64) Sep 16 2010 19:43:16 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 (Build 7600: )

2005;

Microsoft SQL Server 2005 - 9.00.4053.00 (Intel X86) May 26 2009 14:24:20 Copyright (c) 1988-2005 Microsoft Corporation Workgroup Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

Now,My question is; I setup to linked to SQL Server 2005 from SQL Server 2008 under the Server Object.But,When I query , I am receiving the following error.

select * from [192.x.x.x].DBName.dbo.TableName

Result;

Msg 7399, Level 16, State 1, Line 1

The OLE DB provider "SQLNCLI10" for linked server "192.x.x.x" reported an error. The provider did not give any information about the error.

Msg 7312, Level 16, State 1, Line 1

Invalid use of schema or catalog for OLE DB provider "SQLNCLI10" for linked server "192.x.x.x". A four-part name was supplied, but the provider does not expose the necessary interfaces to use a catalog or schema.

Thanks in advance,

Cheers,

share|improve this question
    
When you script your linked server, what does it generate please? –  gbn Jan 30 '11 at 16:51

1 Answer 1

up vote 3 down vote accepted

I once came across a similar problem - I've just dug out the MSDN Blog article I used to fix it. Don't know if this will help you too?

share|improve this answer
    
Good call. Somewhat obscure though... –  gbn Jan 30 '11 at 19:28
    
Thanks for your answer.The problem solved. –  Cell-o Jan 30 '11 at 20:08
    
@Cell-o please mark the answer as accepted by checking the green mark under the question voting slots. –  jcolebrand Jan 31 '11 at 14:25

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.