Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Link server between SQL 2012 AND SQL 2000 Expand / Collapse
Author
Message
Posted Thursday, November 8, 2012 8:07 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, July 1, 2014 3:13 AM
Points: 71, Visits: 27
Hi Friends

I have try to configure link server from SQL 2012 to SQL 2000, when i realize its not supported using the native client 11.0.

so i have installed the native cliend 10.0 (SQL 2008) and i got this error :


The OLE DB provider "SQLNCLI10" for linked server "linkservername" supplied inconsistent metadata for a column. The column "GatewayID" (compile-time ordinal 1) of object ""Billingdb"."dbo"."lkGateway"" was reported to have a "Incomplete schema-error logic." of 0 at compile time and 0 at run time.


can any one know how can i solved this issue OR how i can connect from SQL 2012 to SQL 200

Thanks
Guy
Post #1382516
Posted Wednesday, November 28, 2012 12:18 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, November 12, 2013 7:39 AM
Points: 1, Visits: 8
I'm having the same problem. Any news?
Post #1390054
Posted Wednesday, November 28, 2012 2:30 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, January 16, 2013 4:23 PM
Points: 415, Visits: 2,333
Kelster (11/28/2012)
I'm having the same problem. Any news?


I use SQLOLEDB !
Post #1390136
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse