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

    Unanswered: from excel connect to db2

    i want to learn , how can i connect from excel to db2?

    when i m trying to conect ,i m getting this message
    SQL0440 No authorized routine named "SQLTABLES" of type '"'
    having campatible arguments was found.
    SQLSTATE=42884

    how can i do that?

  2. #2
    Join Date
    Jul 2003
    Location
    Austin, TX, USA
    Posts
    278

    ODBC

    Hi,

    Please first create an ODBC Bridge using the correct DB2 Driver, for that you will have to download and install the db2 client, then you can catalog the node at your end and register it for odbc.

    Then using the get external data source option you can connect to db2.

    Please let us know your db2 version, fix packs applied and operating system in subsequent posts that does help us a lot to understand your problem better.

    Cheers

    Nitin.
    HTH

    Nitin

    Ask the experienced rather than the learned

  3. #3
    Join Date
    Jan 2004
    Posts
    31

    from odbc(with excel) connect db2

    Hi nitin , first thanks for your answer,

    you ask me db2 version

    we are 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?

  4. #4
    Join Date
    Jul 2003
    Location
    Austin, TX, USA
    Posts
    278

    Get External Data

    Hi,

    Now that you have created an ODBC bridge you can use the date -- > import external data --> new database query.

    Choose your ODBC datasource and then you will be able to see the tables and finally get all the data desired.

    HTH

    Nitin
    HTH

    Nitin

    Ask the experienced rather than the learned

Posting Permissions

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