请问JBuilder2006 JDBC怎么连接db2数据库？

sylssgw

win下的db2客户端连接db2服务端数据库失败：（
ODBC　db2 clp可以连接db2服务端

但是JBuilder2006中做以下步骤Database Pilot不能连接

我做的步骤是：
第一步：将C:\Program Files\IBM\SQLLIB\java\db2java.zip改名为db2java.jar 复制到D:\Borland\JBuilder2006\jdk1.5\lib目录下   
第二步：JBuilder中配置lib。   
              JBuilder-->Tools-->Configure   Libraries-->New一个db2l的libraries，Location值为JBuilder。   
第三步：重新启动JB。   
第四步：配置你的database   pilot。   
          a.JBuilder-->Tools-->Database   Pilot-->View-->Options-->Drivers-->Add名为COM.ibm.db2.jdbc.app.DB2Driver的驱动。   
  b.Database   Pilot-->New-->Driver为COM.ibm.db2.jdbc.app.DB2Driver
      URL为jdbc:db2://db2服务端IP地址:50000/db2服务端数据库名

报错：
See com.borland.dx.dataset.DataSetException error code:  BASE+85
com.borland.dx.dataset.DataSetException: The URL: jdbc:db2://32.188.32.2:50000/jsrun could not be found.  Check for misspellings, and that the right driver is present on the classpath.
        at com.borland.dx.dataset.DataSetException.mkUrlNotFoundInDesign(Unknown Source)
        at com.borland.dx.sql.dataset.Database.openConnection(Unknown Source)
        at com.borland.jdbcx.metadata.DatabaseInfo.openConnection(Unknown Source)
        at com.borland.jdbcx.metadata.d.run(Unknown Source)
Chained exception:
java.sql.SQLException: No suitable driver
        at java.sql.DriverManager.getConnection(DriverManager.java:545)
        at java.sql.DriverManager.getConnection(DriverManager.java:171)
        at com.borland.dx.sql.dataset.Database.openConnection(Unknown Source)
        at com.borland.jdbcx.metadata.DatabaseInfo.openConnection(Unknown Source)
        at com.borland.jdbcx.metadata.d.run(Unknown Source)

请帮忙解决为感！
请问我的C:\Program Files\IBM\SQLLIB\java目录中
怎么只有db2jcc.jar和db2java.zip两个文件
怎么没有
C:\Program Files\IBM\SQLLIB\java\db2jcc_license_cu.jar
C:\Program Files\IBM\SQLLIB\java\db2jcc_license_cisuz.jar
这两个文件？？

sylssgw

改用
Driver:COM.ibm.db2.jdbc.net.DB2Driver
URL：jdbc:db2://remoteIP地址:6789/数据库名

报错：
See com.borland.dx.dataset.DataSetException error code:  BASE+66
com.borland.dx.dataset.DataSetException: [IBM][CLI Driver] CLI0106E  连接关闭。 SQLSTATE=08003
        at com.borland.dx.dataset.DataSetException.a(Unknown Source)
        at com.borland.dx.dataset.DataSetException.throwException(Unknown Source)
        at com.borland.dx.dataset.DataSetException.SQLException(Unknown Source)
        at com.borland.dx.sql.dataset.Database.openConnection(Unknown Source)
        at com.borland.jdbcx.metadata.DatabaseInfo.openConnection(Unknown Source)
        at com.borland.jdbcx.metadata.d.run(Unknown Source)
Chained exception:
COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] CLI0106E  连接关闭。 SQLSTATE=08003
        at COM.ibm.db2.jdbc.net.SQLExceptionGenerator.throw_SQLException(Unknown Source)
        at COM.ibm.db2.jdbc.net.SQLExceptionGenerator.check_return_code(Unknown Source)
        at COM.ibm.db2.jdbc.net.DB2Connection.SQLConnect(Unknown Source)
        at COM.ibm.db2.jdbc.net.DB2Connection.SQLConnect(Unknown Source)
        at COM.ibm.db2.jdbc.net.DB2Connection.create(Unknown Source)
        at COM.ibm.db2.jdbc.net.DB2Connection.<init>(Unknown Source)
        at COM.ibm.db2.jdbc.net.DB2Driver.connect(Unknown Source)
        at java.sql.DriverManager.getConnection(DriverManager.java:525)
        at java.sql.DriverManager.getConnection(DriverManager.java:171)
        at com.borland.dx.sql.dataset.Database.openConnection(Unknown Source)
        at com.borland.jdbcx.metadata.DatabaseInfo.openConnection(Unknown Source)
        at com.borland.jdbcx.metadata.d.run(Unknown Source)

改用
URL：jdbc:db2://remoteIP地址:50000/数据库名

报错：
COM.ibm.db2.jdbc.DB2Exception: [IBM][JDBC Driver] CLI0616E  打开套接字时出错。SQLSTATE=08S01
        at COM.ibm.db2.jdbc.net.SQLExceptionGenerator.socketException(Unknown Source)
        at COM.ibm.db2.jdbc.net.DB2Connection.create(Unknown Source)
        at COM.ibm.db2.jdbc.net.DB2Connection.<init>(Unknown Source)
        at COM.ibm.db2.jdbc.net.DB2Driver.connect(Unknown Source)
        at java.sql.DriverManager.getConnection(DriverManager.java:525)
        at java.sql.DriverManager.getConnection(DriverManager.java:171)
        at com.borland.dx.sql.dataset.Database.openConnection(Unknown Source)
        at com.borland.jdbcx.metadata.DatabaseInfo.openConnection(Unknown Source)
        at com.borland.jdbcx.metadata.d.run(Unknown Source)

哪位高手请帮忙看看

sylssgw

问题已解决
db2java.zip 里包含两个驱动:
COM.ibm.db2.jdbc.app.DB2Driver
     这个驱动用来连本机的db2
     此时的URL为jdbc:db2:<databasename>
COM.ibm.db2.jdbc.net.DB2Driver
     这个驱动用来连remote主机的db2
     此时的URL为jdbc:db2://<hostip>:<port>/<databasename>
     用6789端口
数据库50000端口没起