Configuring DA to Use the Microsoft SQL Server JDBC Driver

To use a Microsoft SQL Server database in a comparison, configure the DA server and the DA agent to use the sqljdbc4.jar file.

  1. Download the sqljdbc4.jar JDBC driver for your database version from the Microsoft Web site.
  2. Copy the sqljdbc4.jar file into the DA library folder:
    • On Windows – %SYBASE%\DA-15_5\server\lib\
    • On UNIX – $SYBASE/DA-15_5/server/lib/
    where %SYBASE% (Windows) or $SYBASE (UNIX) is the directory in which you installed the Data Assurance Option, and lib is the library folder of your DA server instance.
  3. Restart the DA server for the settings to take effect.

    Follow the same steps to configure a DA agent to use the Microsoft SQL Server JDBC driver JAR file.