Setting the CLASSPATH Environment Variable

Learn to set the CLASSPATH environment variable.

  1. Install the JDBC driver on the host machine where Replication Agent resides or where Replication Agent can access it.
  2. 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.
  3. Click Apply, then OK.

You can find a description of the Replication Agent configuration parameters that must be set in the Replication Agent Installation Guide > Preparing for Installation.