Download ODBC Drivers for Oracle, SQL Server, Salesforce, MongoDB, Access, Derby, InterBase & DB2.

What settings are required to run the ODBC-JDBC Gateway with Microsoft SQL Server?

ODBC-JDBC Gateway ODBC data source setting Value
Driver Class com.microsoft.sqlserver.jdbc.SQLServerDriver
Class Path jarfiledir\sqljdbc4.jar

where jarfiledir is the directory where the SQL Server JDBC driver .jar file is located. For example:

C:\Program Files\Microsoft SQL Server JDBC Driver\sqljdbc_2.0\enu\sqljdbc4.jar

–Or–

/home/usr1/mssqlserverjdbc/Driver/sqljdbc_2.0/enu/sqljdbc4.jar
URL jdbc:microsoft:sqlserver://SERVER_NAME\INSTANCE_NAME

Note Ensure that there are no trailing spaces left at the end of the Driver Class value.