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?

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

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?

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?

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.