Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Can connect to AS400/DB2 in RazorSQL but not SQL Developer

RarpOct 20 2014 — edited Oct 20 2014

Hi there,

I have a v6.1 AS400/DB2 at my workplace that we are currently looking at migrating to an Oracle database. For the time being, I would like to be able to connect to both databases in SQL Developer so that I can show some things to my employer.

I have downloaded the JTOPEN driver and placed it into a folder, and have added the jar file to the Third Party JDBC drivers list. After I do that I get a DB2 tab when I open a new connection, but it won't accept my parameters. The error it gives is: "Status : Failure -Test failed: Driver class not found. Verify the Driver location".

When I use the JTOPEN jar to connect to DB2 with RazorSQL, it works fine! I know I could use RazorSQL, but I would much prefer to use SQL Developer.

Can anyone point me in the right direction here to get it setup and working properly? I feel as if it's not looking for the driver in the proper location.

Thank you,

Justin

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 17 2014
Added on Oct 20 2014
1 comment
1,579 views