《Squirrel SQL 如何连接IBM db2》由会员分享，可在线阅读，更多相关《Squirrel SQL 如何连接IBM db2（1页珍藏版）》请在金锄头文库上搜索。
1、Squirrel SQL 如何连接IBM db2Configure Squirrel SQL to connect to IBM DB2Squirrel SQL is a great light weight generic SQL client that I have started using for more than 7 years now.This is how to configure Squirrel SQL 3.3.0 to connect to DB2 server, I have installed IBM DB2 admin client 9.7 - 64 bit sof
2、tware on my Windows 7 enterprise SP1. You will find two types of DB2 drivers APP & NET,most recommended way is to use type 4 JDBC driver (thin) that actually doesnt require client installation, but require proper jar files and associated license.Steps:1- Open Driver list from left menu, click the pl
3、us sign Createa New Driver.2- Type IBM DB2 Universal Driver in Name textbox.3- Type jdbc:db2:/:/ in Example URL textbox.4- Type com.ibm.db2.jcc.DB2Driver in Class Name editable dropdown list.5- Click Extra Class Path tab.6- Click Add and select two jar files from%DB2_INSTALL%javadb2jcc.jar & %DB2_INSTALL%javadb2jcc_license_cu.jar7- Click Ok, and we are done defining the driver.8- Now create an alias for the DB using previous driver and providing URL, username, & password.Your driver dialog should look like:
