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\drivers\sqljdbc4.jar
   • On UNIX – $SYBASE/DA-15_5/server/lib/drivers/sqljdbc4.jar

   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. Open the RUN start-up script file:
   • On Windows 32-bit:

     %SYBASE%\DA-15_5\server\instance\RUN_instance_32.bat

   • On Windows 64-bit:

     %SYBASE%\DA-15_5\server\instance\RUN_instance_64.bat

   • On UNIX:

     $SYBASE/DA-15_5/server/instance/RUN_instance_64.sh

   where instance is the name of your DA server instance.

4. Add the location of the Microsoft SQL Server JDBC driver JAR file to the DA server CLASSPATH.
   On Windows:

   set CLASSPATH=%CLASSPATH%;%DA_LIB%\drivers\sqljdbc4.jar

   On UNIX:

   set CP=$CP:$DA_LIB/drivers/sqljdbc4.jar

5. Save the RUN start-up script file.
6. 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.