Post reply

Creating a View against a Linked Server

  • 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

  • January 22, 2007 at 8:00 am

    This was removed by the editor as SPAM

  • 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

  • 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.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply