Hi,

you need another driver, you'll find it at
http://www-1.ibm.com/servers/eserver/iseries/toolbox/downloads.htm
its an pure java driver and runs on any java system. The driver class is
com.ibm.access.AS400JDBCDriver
the url you need is
jdbc:as400://HostName/DefaultSchema

Dieter Bender

Hello !

No, you need to download jt400.jar library, if you have IBM Client Access
installed try to search that file.

Then, the connection method is rather simple, see my sample code below ( you
have to change some line to get it works )

/* (non-Javadoc)
 * @see jdbconn.model.dbengine#openConnection()
 */
public Connection openConnection(String IP,String DBname,String UID,String
PSW) {

 this.server = IP;
 this.dbName = DBname;
 this.uid = UID;

 Connection db2Conn = null;
 try {
             DriverManager.registerDriver(new
com.ibm.as400.access.AS400JDBCDriver());
             db2Conn =
DriverManager.getConnection("jdbc:as400://"+IP+"/"+DBname+";user="+UID+";pas
sword="+PSW);
             return db2Conn;
        } catch (SQLException e) {
           System.out.println("Error while connecting to "+IP+" with
user="+UID);
           System.out.println("SQLException: "+e.getMessage());
           System.out.println("SQLState: "+e.getSQLState());
           System.out.println("Vendor Error: "+e.getErrorCode());
       return null;
        }
}

Hoping this helps,
ciao
Alberto