Start Here   Setup   Adapters   Studio   Server   Monitor   Mapping   Scripting   Samples   Index 

Database Drivers

 Software Setup    Unix Setup    iSeries Setup    Windows Setup    Configuration Settings    Database Drivers  

JDBC Database Drivers

ActiveLink contains various Java Database Connectivity (JDBC) adapters that use any JDBC or ODBC compliant driver to access the specified database. Custom and 3rd party JDBC Drivers can be added to ActiveLink as easily as copying a file (see below).

JDBC Drivers shipped with ActiveLink

The following JDBC Drivers are included with ActiveLink.

Type Driver Class
JDBC-ODBC Bridge sun.jdbc.odbc.JdbcOdbcDriver
IBM iSeries com.ibm.as400.access.AS400JDBCDriver
IBM DB/2 com.ibm.db2.jdbc.app.DB2Driver
Microsoft SQL Server com.microsoft.jdbc.sqlserver.SQLServerDriver
MySQL org.gjt.mm.mysql.Driver
Oracle oracle.jdbc.driver.OracleDriver

Adding a JDBC Driver

If you need to use a JDBC driver other than the ones listed above, its jar file must be added to the lib directory.

  1. Copy the jar file containing the JDBC Driver into the activelink\lib directory.
  2. Re-start Design Studio
  3. In the JDBC Task properties, type the JDBC Driver class name

Next: Plugin Adapters

 Start Here   Setup   Adapters   Studio   Server   Monitor   Mapping   Scripting   Samples   Index 

ActiveLink Help - Version 4.1.1
© 2006 ActiveCore Technologies Inc.
activelink@activecore.com