Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2004
    Posts
    31

    Unanswered: from ODBC connect to db2 (with excel)

    from ODBC(with excel) connect to db2


    i m using db2 7.1 version ,fix pack 8.1 and db2 connect 8.1 version

    i created odbc bridge and i installed other programs

    after what must i do?

  2. #2
    Join Date
    Aug 2003
    Location
    India
    Posts
    30
    After ODBC setup has been completed.

    Open the Excel Sheet Go to data tab and click on the get external data
    New database Query.

    Select the ODBC which you had configured and pass the Query to it

    I believe this will do

    Cheers,
    Pushp

  3. #3
    Join Date
    Jan 2004
    Posts
    31
    hi cheers, thanks and

    i did odbc connections and this message showing

    " SQL0440 No authorized routine named "SQLTABLES" of type '"'
    having compatible arguments was found.
    SQLSTATE=42884"

    problem maybe , on db2 security?

  4. #4
    Join Date
    Jan 2004
    Posts
    31

    ODBC

    Hi cheer ,

    i can connect from oracle to db2 normally but

    with ODBC driver i cant , it doesnt
    i think where am i doing mistake?

  5. #5
    Join Date
    Feb 2003
    Posts
    20

    Re: ODBC

    Perform the following steps and try again:

    db2 connect to DBNAME
    db2 catalog system odbc data source DBNAME
    db2 terminate

    Then try to access the database from Excel.

    If you can access a table from DB2 Command Window, then there is no security issue. You should be able to access the same table from Excel.

Posting Permissions

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