Problems with establishing connection to DB2 from Crystal

[Videla]

Hi All,
I have Crystal report XI and i am trying to establish a connection to DB2. I tried report wizard to create a report using DB2 Connectio but while creating a connec tion following error occured. I can even create a command and execute queries to DB 2 and also able to fetch the data to report. Can anyone help me on listing the Db 2 tables once i established the connection to DB 2.

ERROR
------------------------------------------------------------
DATABASE CONNECTOT ERROR 42724;IBM CLI DRIVER DB2/SUN64 SQL 0444N ROUTINE "SQLTABLES" IN IMPLEMENTED IN CLASS LIBRARY OR PATH. REASON CODE:4 SQLSTATE=42724. DATABSE VENDOR CODE:-444

 

[synapsevampire]

Are you connecting to tables, a View or an SP?

Here are some possibilities:

http://eai.ittoolbox.com/groups/technical-functional/db2-l/642353

http://www.developer.ibm.com/isv/tech/faq/individual.jsp?oid=1:82922

Everything I read related to SPs, hopefully one of the above will help.

-k

 

[Videla]

Thanks for your Info. I am trying to connect to a table. Can you help me on connecting to DB 2 table.

Other Details:
DB ver 8.1
Crystal report XI

Trying to connect thru ODBC. I tested out the connection with other Front end application like .Net, it works fine. But when i use the same ODBC to connect to Db2 from Crystal report i am getting an error. Any help would be appreciated.

ERROR
------------------------------------------------------------
DATABASE CONNECTOT ERROR 42724;IBM CLI DRIVER DB2/SUN64 SQL 0444N ROUTINE "SQLTABLES" IN IMPLEMENTED IN CLASS LIBRARY OR PATH. REASON CODE:4 SQLSTATE=42724. DATABSE VENDOR CODE:-444