By default, after installing ESD #5 or later, the new Replication Agent for Microsoft SQL Server instances that you create are configured to use the Microsoft SQL Server JDBC driver. You can use this driver on both Windows and UNIX systems.
To use the Microsoft SQL Server JDBC driver
Retrieve the Microsoft SQL Server JDBC driver http://msdn.microsoft.com/data/ref/jdbc/ (enter the URL all on one line), and install the JDBC driver on the same machine on which the Replication Agent is running or where Replication Agent can access it.
Before starting the Replication Agent, add the location of the JDBC driver to the CLASSPATH environment variable:
On UNIX, enter:
setenv CLASSPATH /path_name/sqljdbc.jar:$CLASSPATH
where path_name is where you installed the Microsoft SQL Server JDBC driver.
On Windows 2000 or 2003, 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 by entering the following:
drive:\path_name\sqljdbc.jar
where:
drive is the drive letter
path_name is the name of the path where you installed the Microsoft SQL Server JDBC driver
Click Apply and then OK.
For an existing Replication Agent for Microsoft SQL Server instance to retrieve the new value for the CLASSPATH environment, do the following:
On UNIX, stop the Replication Agent instance, define the CLASSPATH as described in step #2, and then restart the instance.
On Windows, stop the Replication Agent, close the DOS window, define the CLASSPATH as described in step #2, open a new DOS window, and then restart the Replication Agent instance.
For an existing Replication Agent for Microsoft SQL Server instance, in ADMIN mode, configure the pds_connection_type to use the Microsoft SQL Server JDBC driver:
ra_config pds_connection_type, MSSQLJDBC
Then stop and restart the existing instance.
For new instances of Replication Agent for Microsoft
SQL Server that you create after applying ESD #5 or later, MSSQLJDBC is
the default value.
In Replication Agent, configure the following properties using values appropriate for the primary Microsoft SQL Server:
ra_config pds_server_name, <server>ra_config pds_port_number, <port>ra_config pds_database_name, <database>ra_config pds_username, <ra_user>ra_config pds_password, <ra_pwd>
For more information, see the Replication Agent Administration Guide.
