0 Replies Latest reply: Aug 24, 2012 8:22 AM by 460076 RSS

    Connect OWB 11.2.0  with AS/400 , iSeries DB2

    460076
      Hi ,

      We are trying to get a connection to db2 on a as400. What ever we try jtopen etc we fail.

      We can make a connection to the DB2 database but we cannot see any table at all.

      I used the tcl script as the sample but I just can see the schemas but not tables .

      OMB+> source g:/Data_work/IBM_jdbc/jdbc_info_1.tcl
      Schema: XXX
      Schema: XXX
      Schema: XXX
      Schema: XXX
      Schema: XXX
      Schema: XXX
      Schema: XXX
      OMB+>
      set driver "com.ibm.as400.access.AS400JDBCDriver"
      set connect "jdbc:as400://XX.XX.X.XX;naming=sql;errors=full;date format=iso"
      set username "XXX"
      set pass "XXX"
      I also tried with this driver DSClients--jdbc_sqlj-9.7.0.1 IBM Data Server Driver for JDBC and SQLJ V9.7 Fix Pack 1
      I copy this two files db2jcc.jar db2jcc4.jar and keep the files db2jcc_license_cu.jar, db2jcc_license_cisuz.jar
      I change your tcl script
      set driver "com.ibm.db2.jcc.DB2Driver"
      set connect "jdbc://73.37.0.42;naming=sql;errors=full;date format=iso"
      set username "XXX"
      set pass "XXX"

      C:\owb11g\owb\bin\win32>OMBPlus.bat c:\jdbc_info_db2.tcl
      java.sql.SQLException: No suitable driver

      But I get this error, I and tried with the Design Center, and I can connect but I can't see the tables.

      Someone that can help us.

      Thanks for your help.