I've got a brand new setup, nothing unusual, assume defaults across the board:
Windows XP SP2
Java Eclipse 3.2
SQL Explorer 3.0.0
IBM DB2 9.1 Express-C
Had no problems connecting to MySQL 5 through SQL Explorer. Works like a champ.
I can't find a single resource through countless hours of Googling explaining how to connect to DB2 through SQL Explorer.
This is the error message:
Error adding driver COM.ibm.db2.jdbc.app.DB2Driver
Just for the heck of it, I tried utilizing the "MySQL" driver format tweaking the database name from MySQL to DB2 like so:
com.db2.jdbc.Driver
Amazingly, SQL Explorer accepted it. But upon trying to connect, it complained that the URL was invalid.
I also tried using the default Driver class name in SQL Explorer for IBM DB2: COM.ibm.db2.jdbc.net.db2driver
Again, SQL Explorer accepted it but when I try to connect, a "Connection" box pops up with a big red "X" and that's about it.
I'm really confused.
Can anyone help straighten this out for a DB2 Noob?
Thanks
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I've got a brand new setup, nothing unusual, assume defaults across the board:
Windows XP SP2
Java Eclipse 3.2
SQL Explorer 3.0.0
IBM DB2 9.1 Express-C
Had no problems connecting to MySQL 5 through SQL Explorer. Works like a champ.
I can't find a single resource through countless hours of Googling explaining how to connect to DB2 through SQL Explorer.
Using the following (Including class path):
$IBM\SQLLIB\java\db2jcc.jar
$IBM\SQLLIB\java\db2jcc_license_cu.jar
Driver class name: COM.ibm.db2.jdbc.app.DB2Driver
Connection URL: jdbc:db2://localhost:50000/
This is the error message:
Error adding driver COM.ibm.db2.jdbc.app.DB2Driver
Just for the heck of it, I tried utilizing the "MySQL" driver format tweaking the database name from MySQL to DB2 like so:
com.db2.jdbc.Driver
Amazingly, SQL Explorer accepted it. But upon trying to connect, it complained that the URL was invalid.
I also tried using the default Driver class name in SQL Explorer for IBM DB2: COM.ibm.db2.jdbc.net.db2driver
Again, SQL Explorer accepted it but when I try to connect, a "Connection" box pops up with a big red "X" and that's about it.
I'm really confused.
Can anyone help straighten this out for a DB2 Noob?
Thanks