JDBC drivers for Oracle and Microsoft SQL Server databases are provided by the database vendors. If the JDBC driver for your database is not already installed, obtain the appropriate driver from the Web site of the vendor.
For the JDBC driver for Oracle
For the JDBC driver for Microsoft SQL Server and search for “SQL Server 2005 JDBC driver.”
Setting the CLASSPATH environment variable
Install the JDBC driver on the host machine on which Replication Agent resides or where Replication Agent can access it.
Replication Agent for Microsoft SQL Server must
be installed on Microsoft Windows.
Add the location of the JDBC driver to the CLASSPATH environment variable.
For UNIX: (Microsoft SQL Server is not available on UNIX)
Add the following to the .login file of the user account that is used to start and stop the Replication Agent instance:
setenv CLASSPATH /path_name/driver:$CLASSPATH
where:
path_name is the name of the path where you installed the JDBC driver.
driver is the name of the JDBC driver. (For Oracle, it is ojdbc5.jar)
You must log out and log back in for this change to take effect, or issue the command source .login after the change.
For Microsoft Windows:
Go to Start | Settings | Control Panel | System | Environment, and add the following to the existing CLASSPATH environment variable, using the semicolon (;) as the path separator, or create the path in the User Variables pane:
drive:\path_name\driver
where:
drive is the drive letter.
path_name is where you installed the JDBC driver.
driver is the name of the JDBC driver:
For Oracle, the name is ojdbc5.jar
For Microsoft SQL Server, the name is sqljdbc.jar.
Click Apply, then OK.
On the Oracle host machine, the Oracle primary server must be running the Transparent Network Substrate (TNS) Listener Service. See the Oracle networking document for more information about TNS.
