I have a MSSQL2008 and MSSQL2005 in my system.All SP's is up-to-date.
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: )
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 ;
Msg 7399, Level 16, State 1, Line 1
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
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,