Replication Agent requires a JDBC driver to communicate with the primary database. JDBC drivers for Microsoft SQL Server databases are provided by third-party database vendors. If the JDBC driver for your database is not already installed, obtain the appropriate driver from the vendor’s Web site. Refer to the Replication Agent Release Bulletin for the latest version of the Microsoft SQL Server JDBC.
Setting the CLASSPATH environment variable
Install the JDBC driver on the host machine where Replication Agent resides or where Replication Agent can access it.
Add the location of the JDBC driver to the CLASSPATH environment variable:
Select 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 where you installed the JDBC driver.
driver is the name of the JDBC driver. For Microsoft SQL Server, the name is sqljdbc.jar.
Click Apply, then OK.
You can find a description of the Replication Agent configuration parameters that must be set in Chapter 1 “Preparing for Installation” in the Replication Agent Installation Guide.
