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

<a href="/cgi-bin/account/login.cgi">Log In</a> <a href="/cgi-bin/account/logout.cgi">Log Out</a>/<a href="/cgi-bin/account/register.cgi">Register</a>

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

Easysoft ODBC-JDBC Gateway

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

Article:: 01013

Last Reviewed:: 26th January 2024

Revision:: 1

ODBC-JDBC Gateway DSN Setting	Value
Driver Class	com.microsoft.sqlserver.jdbc.SQLServerDriver
Class Path	`jarfiledir`\sqljdbc4.jar where `jarfiledir` is the directory where the SQL Server 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`

ODBC-JDBC Gateway DSN Setting

Value

Driver Class

com.microsoft.sqlserver.jdbc.SQLServerDriver

Class Path

jarfiledir\sqljdbc4.jar

where jarfiledir is the directory where the SQL Server 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.

Applies To

Products
- Easysoft ODBC-JDBC Gateway
Databases
- Microsoft SQL Server

Knowledge Base Feedback

Legal
Privacy Statement

© 1993 - 2024 Easysoft Limited. All rights reserved. Oracle® is a registered trademark of Oracle® Corporation and/or its affiliates. Other trademarks and registered trademarks appearing on easysoft.com are the property of their respective owners.

Easysoft ODBC-JDBC Gateway