KB Article #179109

JDBC driver to connect to SQL Server 2008

Problem

-- I am using a customer function that connects to a Microsoft SQL Server 2008 database

-- which driver should I use ?

Resolution


* according to the support catalog reference documentation https://support.axway.com/fr/documents/document-de... :

Drivers are automatically provided in the kit for MySQL 5.5 and Oracle 11.2. You must add the drivers for DB2 9.7, Microsoft SQL Server 2008 R2, and odbc_.db for AIX 64

* the driver can be found on the Microsoft web site (ex : https://www.microsoft.com/en-us/download/details.a...)

* download the driver (for instance sqljdbc42.jar for JRE8) and copy it in $CORE_ROOT/java/lib/ext