Configuring JDBC/ODBC Drivers

OTD Wizard: Database Connection Information

To connect to AS/400, use the information provided in Table 1–1 to complete the Connect to Database step of the JDBC/ODBC OTD Wizard. To access DB2, it is recommended to use the DB2 eWay Adapter or the DB2 Connect eWay Adapter.

Table 1–1 AS/400 Database Connection Information

Parameter 

Value 

Driver Jar Files 

jt400.jar

Driver Java Class Name 

com.ibm.as400.access.AS400JDBCDriver 

URL Connection String 

jdbc:as400://server-name:server-port/


Note –

NOTE: Default server port is 446.


User Name 

Login name of the account used to access the AS/400 database. 

Password 

Password associated with the login account name used to connect to the AS/400 database.