1 Reply Latest reply on Oct 21, 2014 12:48 AM by rp0428

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

    Rarp

      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