1

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,

Improve this question
1
  • When you script your linked server, what does it generate please?
    – gbn
    Commented Jan 30, 2011 at 16:51

1 Answer 1

Reset to default
2

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?

Improve this answer
2
  • Good call. Somewhat obscure though...
    – gbn
    Commented Jan 30, 2011 at 19:28
  • @milesD, please quote relevant text (or at least a hint) in your answer so that it can benefit others even if/when the provided link no longer works.
    – Jonathan Fite
    Commented Feb 1, 2021 at 13:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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