Results 1 to 7 of 7

Thread: Linked server - Retrieve information on columns

Threaded View

  1. #1
    Join Date
    Dec 2002
    Posts
    50

    Linked server - Retrieve information on columns

    I am trying to retrieve information on columns defined in the destination Unidata table. I am using linked server to connect to the table using Unidata ODBC driver.
    When I issue below command:

    select * from openquery(CADC1, 'select * from INFORMATION_SCHEMA.COLUMNS')

    I get the following error:

    OLE DB provider "MSDASQL" for linked server "CADC1" returned message "[Ardent][UniData ODBC Driver][IBM][SQL Client][UNIDATA]You have no privilege on file COLUMNS".
    Msg 7321, Level 16, State 2, Line 1
    An error occurred while preparing the query "select * from INFORMATION_SCHEMA.COLUMNS" for execution against OLE DB provider "MSDASQL" for linked server "CADC1".

    Does any of you know how to query the destination to get the columns metadata?

    Thanks,
    Lava
    Last edited by Lava; 12-21-2006 at 10:42 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •