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?

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.

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?

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