Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    212

    Exclamation Unanswered: DB2 Linked Server

    I have setup a linked DB2 server and i c the table/view list in EM>Security. But in QA when i run

    select * from servername.catalog.user.tablename

    i get the following error msg:

    Server: Msg 7399, Level 16, State 1, Line 1
    OLE DB provider 'MSDASQL' reported an error. The provider does not support the necessary method.
    [OLE/DB provider returned message: Method is not supported by this provider.]
    OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBSchemaRowset::GetRowset returned 0x80040e53: The provider does not support the necessary method.].

    Any way to solve this?

  2. #2
    Join Date
    May 2003
    Posts
    369

    federated servers for DB2

    You might want to look into creating a federated server in DB2 for your environment to solve these problems. Check the online DB2 support documentation for how to do this.
    Hope this helps.

    Scott

Posting Permissions

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