We are trying to use the JDBC adpter to connect to DB2 V7.1 on the AIX. The Enterprise Integrator is v4.1.1 and the JDBC adapter is V4.2.1. We are not able to configure it to connect to the database. The error that we getting is “(314) Could not connect to database “jdbc:db2:txn” as user “db2inst1” (08001/0) No suitable driver”. What did we do wrong?
JDBC Driver : COM.ibm.db2.jdbc.app.DB2Driver
System NAme or IP Address: our AIX box ip address
Database User: db2inst1
Database Password :
Connection String (URL) : jdbc:db2:txn
Db2 Instance name with DB2 Connect:
Add to CLASSPATH: /usr/lpp/db2_07_01/java12/db2java.zip