Connection for DB2 on AS400

bde
2008-01-31
2013-04-29
  • bde
    bde
    2008-01-31

    I could see in the Connections screen shot at http://www.sqlexplorer.org/connections.php that people had used SQLExplorer to connect to database on an AS400.  I am trying to figure that out and I am having no real luck.

    I was wondering if someone could provide me with an Example URL and the Driver Class that they are using.

    I found an jt400.jar file that contains com.ibm.as400.access.AS400JDBCDriver in it, so that is what I have been trying to use (in a number of tools: DBVisualizer, etc) with no luck.

    I am not an IBM guy, so trying to connect to the iSeries (which I assume is an AS400?) has not been an easy task from a Windows box.

    Thanks for any help that anyone can provide.

     
    • Jason
      Jason
      2008-05-01

      I have working connections to our AS/400's.  I am using the com.ibm.as400.access.AS400JDBCDriver driver class with the following URL template:

      jdbc:as400://<your-server>

      Hope this helps.