Oracle and Microsoft SQL Server JDBC drivers

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, you need to obtain the appropriate driver from the vendor’s Web site and then set the CLASSPATH environment variable:

To obtain the latest Oracle 10.2 driver for JDK 1.4

Select one of these links to the Oracle Database 10g Release 2 drivers:

For the JDBC driver for Oracle

For the JDBC driver for Microsoft SQL Server and search for “SQL Server 2005 JDBC driver.”
Select the ojdbc14.jar classes for use with JDK 1.4 and JDK 1.5.

To set the CLASSPATH environment variable

Install the JDBC driver on the host machine on which Mirror Replication Agent resides or where Mirror Replication Agent can access it.

Mirror 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 Mirror 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 ojdbc14.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 panel:
```
drive:\path_name\driver
```
  where:
  - drive is the drive letter.
  - path_name is the name of the path where you installed the JDBC driver.
  - driver is the name of the JDBC driver:
    - For Oracle, the name is ojdbc14.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.