Configuring 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 – NOTE: 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 – NOTE: 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 eWay Environment properties for Sequelink DataDirect MS Access ODBC.