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 vendor’s Web site.
For Oracle:http://technet.oracle.com/software/tech/java/sqlj_jdbc/content.html
For Microsoft SQL Server: http://www.microsoft.com/downloads/Browse.aspx?displaylang=en&categoryid=3
To set the CLASSPATH environment variable
Install the JDBC driver on the machine on which Sybase Replication Agent resides or where Sybase Replication Agent can access it.
Add the location of the JDBC driver to the CLASSPATH environment variable.
For 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 ojdbc14.jar, and for SQL Server it is sqljdbc.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 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 window:
drive:\path_name\driver
where:
drive is the drive letter.
path_name is the name of the path where you installed the Oracle JDBC driver.
driver is the name of the JDBC driver: For Oracle, the name is ojdbc14.jar, and for SQL Server, the name is sqljdbc.jar.
Click Apply, and then OK.
On Oracle, the Oracle primary server must be running the Transparent Network Substrate (TNS) Listener Service. See the Oracle networking document for more information about TNS.
