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.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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.
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.