Creating a View against a Linked Server

• Joseph F. Goucher

  Newbie

  Points: 9

  More actions

  January 17, 2007 at 8:36 am

  #68690

  I get the following error when I try and create a view that references a successfully created  Linked Server in Microsoft SQL to an Advantage Database Server v8.1 database.  I am using the Advantage StreamlineSQL ODBC driver.

   Here's the error:

  [Microsoft][ODBC SQL Server Driver][SQL Server]OLE DB error trace [Non-interface error: OLE/DB provider returned an invalid column definition.].

  I can not find anything except in how the error relates to Oracle.

  I have looked at some of the data files and I do not see any foreign data that is inconsistent with the data-type for the field.

  Thanks,

  Joseph

• Tahir-191992

  Mr or Mrs. 500

  Points: 584

  More actions

  January 24, 2007 at 3:19 am

  #685149

  Don't know about Advantage Database Server v8.1 database.

  Can u run a Select query againt this linked server usign fully qualified table name,  mean with out View ???

  ---

  Kindest Regards,

  Tahir
  

• Joseph F. Goucher

  Newbie

  Points: 9

  More actions

  January 24, 2007 at 9:30 am

  #685265

  I was able to get a view to work with the OpenQuery command.  So, for each table I'll have this created and then have the necessary views reference that.

   

  Thanks for the help.