The use of a SQL Server database with Sterling B2B Integrator requires the installation of a
JDBC driver.
Sterling B2B Integrator requires the correct Microsoft SQL Server driver. See the System
Requirements for the supported version information.
Download the driver and
any appropriate patches from the Microsoft website.
To install the JDBC driver in Microsoft SQL Server:
- 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.