Websphere Info. Integr. (DB2) access error [message #48961] |
Wed, 22 June 2005 00:07 |
Eclipse User |
|
|
|
Originally posted by: gauravengg.hotmail.com
I am trying to access a websphere Info. Integrator (DB2) database.
It shows a successful connection and the query when creating the data set
also runs correctly.(in data set editor)
When i finally make a table by dragging the columns from the data explorer
view into the table and preview it, it gives me an error
There are errors on the report page:
Error1:Cannot open the connection for the driver (jdbc).
I have included db2jcc.jar and db2jcc_license_cu.jar
and selecting the driver as com.ibm.db2.jcc.DB2Driver (2.3). I am leaving
the display name and URL template blank..
then giving database URL as jdbc:db2:database_name
and testing connection which is successful..
please advise if doing something wrong. as the preview gives error.
Also in problem it dispalys:
The list/table "table1" must be able to access one data set
|
|
|
Powered by
FUDForum. Page generated in 0.03745 seconds