Verifying the Websphere variables

About this task

The JDBC Provider uses WebSphere® environment variables to define the paths to the JDBC driver JAR files. The correct jdbc driver software must be downloaded from Microsoft. The following version is recommended:

Microsoft JDBC Driver 4.0 for SQL Server - sqljdbc_4.0.2206.100_enu.exe

Download the SQL Server jdbc driver and copy it to the root drive of the server. Run the file to extract the driver. The sqljdbc4.jar file is extracted to the following directory structure:

C:\extract_path\sqljdbc_4.0\enu\

where extract_path is the directory chosen when you unzipped the file.

Note: The path cannot contain any spaces.
Verify that the correct values are defined by completing the following steps:

Procedure

  1. Select Environment / WebSphere Variables.
  2. Click MICROSOFT_JDBC_DRIVER_PATH and verify that this points to the Microsoft SQL Server JDBC driver, sqljdcb4.jar file that you extracted.
  3. Click OK.
  4. Click Save.