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.