beautypg.com

A.1 as/400 toolbox driver, A.1.1 otd wizard: database connection information, As/400 toolbox driver – Sun Microsystems eWay JDBC/ODBC Adapter User Manual

Page 118: Otd wizard: database connection information

background image

Appendix A

Section A.1

JDBC/ODBC Drivers

AS/400 Toolbox Driver

JDBC/ODBC eWay Adapter User’s Guide

118

Sun Microsystems, Inc.

What’s In This Chapter:

ƒ

AS/400 Toolbox Driver

on page 118

ƒ

Attunity Driver

on page 119

ƒ

MySQL Connector/J Driver

on page 121

ƒ

PostgreSQL Driver

on page 122

ƒ

SyBase JConnect Driver

on page 124

ƒ

Sequelink DataDirect Informix ODBC Driver

on page 125

ƒ

Sequelink DataDirect MS Access ODBC Driver

on page 126

ƒ

Teradata Driver

on page 128

ƒ

Installing JDBC/ODBC Drivers

on page 129

ƒ

Troubleshooting

on page 130

Refer to the supplied Readme.txt file for information regarding the location of the
required driver files necessary to connect using the JDBC/ODBC eWay.

A.1

AS/400 Toolbox Driver

Configuration Properties:

ƒ

OTD Wizard: Database Connection Information

on page 118

ƒ

Environment Properties

on page 119

A.1.1

OTD Wizard: Database Connection Information

To connect to AS/400, use the information provided in Table 24 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 24 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://:/

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.