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

    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
    Dec 2002
    Posts
    1,245

    Re: DB2 Linked Server

    What OLE DB Provider are you using? I have had no luck with the standard ones provided by IBM; I have heard of others who have used 3rd party drivers with great success.

    Regards,

    hmscott

    Originally posted by vmlal
    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?

  3. #3
    Join Date
    Sep 2003
    Posts
    212
    I'm using the OLE DB Provider as follows:
    srvproduct: DB2OLEDB
    providername: MSDASQL

    I have installed the right drivers for DB2 etc.

    What other 3rd party tools would be helpful? any ideas?

    thx

  4. #4
    Join Date
    Dec 2002
    Posts
    1,245
    Sorry it took me so long to get back to you. I had to dig through my e-mails to find the link. Go to www.hitsw.com. On their home page, look in the middle third for a link to "SQL Middleware".

    I have not used their products, but a friend of mine has. He demonstrated the capability to link a DB2 server using the OLE DB provider from Hit Software.

    I hope this helps.

    Regards,

    hmscott


    Originally posted by vmlal
    I'm using the OLE DB Provider as follows:
    srvproduct: DB2OLEDB
    providername: MSDASQL

    I have installed the right drivers for DB2 etc.

    What other 3rd party tools would be helpful? any ideas?

    thx

  5. #5
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621

    Re: DB2 Linked Server

    Originally posted by vmlal
    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?
    Use an openquery instead.

  6. #6
    Join Date
    Sep 2003
    Posts
    212

    Re: DB2 Linked Server

    Originally posted by snail
    Use an openquery instead.

    Doesnt work with openquery either.

    PS: The DB2 is on AIX box

Posting Permissions

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