Link server between SQL 2012 AND SQL 2000

• guy yosef

  SSC Enthusiast

  Points: 169

  More actions

  November 8, 2012 at 8:07 am

  #264497

  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

• Kelster

  Valued Member

  Points: 65

  More actions

  November 28, 2012 at 12:18 pm

  #1563386

  I'm having the same problem. Any news?

• patrickmcginnis59

  SSCertifiable

  Points: 6483

  More actions

  November 28, 2012 at 2:30 pm

  #1563459

  Kelster (11/28/2012)

  ---

  I'm having the same problem. Any news?

  I use SQLOLEDB !