Installing the JDBC driver in Microsoft SQL Server

The use of a SQL Server database with Sterling B2B Integrator requires the installation of a JDBC driver.

About this task

Sterling B2B Integrator requires the correct Microsoft SQL Server driver. See the Software Product Compatibility Reports for the supported version information.

Download the driver and appropriate patches from the Microsoft website.

Procedure

To install the JDBC driver in Microsoft SQL Server, perform the following steps:

Download the sqljdbc_<version>_<language>.tar.gz file to a temporary directory.
To unpack the compressed TAR file, open the directory where you want the driver unpacked and type the following command:
```
gzip -d sqljdbc_<version_language>.tar.gz
```
To unpack the TAR file, open the directory where you want the driver installed and type the following command:
```
tar –xf sqljdbc_<version_language>.tar
```
After the package unpacks, you can find out more information about using this driver by opening the JDBC Help System in the /absolutePath/sqljdbc_<version>/<language>/help/default.htm file. This file displays the help system in your web browser.
When the Sterling B2B Integrator installation asks for the location of the JDBC drivers, specify the extracted JAR file created after you unpack the archive, which is usually named sqljdbc.jar. The JDBC driver version is the same as the version of the drivers that are downloaded from Microsoft.