JavaScript is required to for searching.
Skip Navigation Links
Exit Print View
Configuring JDBC/ODBC Drivers for Oracle Java CAPS     Java CAPS Documentation
search filter icon
search icon

Document Information

1.  Configuring JDBC/ODBC Drivers

About JDBC/ODBC Drivers

Configuring JDBC/ODBC Drivers

AS/400 Toolbox Driver Configuration Properties

OTD Wizard: Database Connection Information

Environment Properties

Attunity Driver Configuration Properties

OTD Wizard: Database Connection Information

Environment Properties

MySQL Connector/J Driver Configuration Properties

OTD Wizard: Database Connection Information

Environment Properties

PostgreSQL Driver Configuration Properties

OTD Wizard: Database Connection Information

Environment Properties

Sybase JConnect Driver Configuration Properties

OTD Wizard: Database Connection Information

Environment Properties

Sequelink DataDirect Informix ODBC Driver Configuration Properties

OTD Wizard: Database Connection Information

Environment Properties

Sequelink DataDirect MS Access ODBC Driver Configuration Properties

OTD Wizard: Database Connection Information

Environment Properties

Teradata Driver Configuration Properties

OTD Wizard: Database Connection Information

Environment Properties

Troubleshooting

Installing JDBC/ODBC Drivers

Sequelink DataDirect MS Access ODBC Driver Configuration Properties

OTD Wizard: Database Connection Information

To connect to Microsoft Access, via the Microsoft Access ODBC driver, use the information provided in Table 1-13 to complete the Connect to Database step of the JDBC/ODBC OTD Wizard.

Table 1-13 MS Access ODBC Driver Database Connection Information

Parameter
Value
Driver Jar Files
sljc.jar
Driver Java Class Name
com.ddtek.jdbc.sequelink.SequeLinkDriver
URL Connection String
jdbc:sequelink://server-name:server-port

Note - The default server port is 19996.


User Name
Login name of the account used to access the database.
Password
Password associated with the login account name used to connect to the database.

Environment Properties

Use Table 1-14 to configure the environment properties for the specified JDBC/ODBC driver.

Table 1-14 MS Access ODBC Driver Environment Properties

Parameter
Value
Description
JDBC Connection Pool Datasource
ClassName
com.ddtek.jdbcx.sequelkink.SequeLinkDataSource
ClassNamefor

OtherInterfaces

ServerName
Server name of the machine hosting Sequelink.
PortNumber
server-port

Note - The default server port is 19996.


DatabaseName
User
Login name of the account used to access the database.
Password
Password associated with the login account name used to connect to the database.
DriverProperties
Delimiter
The default is #.
DataSourceName
MinPoolSize
The default is 0.
MaxPoolSize
The default is 10.
MaxIdleTime
The default is 0.

Note - It is not mandatory to enter driver properties in the Outbound JDBC Adapter Environment properties for Sequelink DataDirect MS Access ODBC.