Linked Server Problem

Last Post 07 Feb 2011 07:00 AM by maxdeveloper. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
maxdeveloper
New Member
New Member

--
30 Jan 2011 06:03 AM
Hi All,

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].mydatabase.mytable ;

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,
rm
New Member
New Member

--
30 Jan 2011 07:37 AM
When you query linked server, need reference it with four-part name like [192.x.x.x].mydatabase.schema.mytable.
maxdeveloper
New Member
New Member

--
07 Feb 2011 07:00 AM
thanks so much
You are not authorized to post a reply.

Acceptable Use Policy