Microsoft SQL Server JDBC Driver

Installing and Configuring the Microsoft SQL Server JDBC Driver

Microsoft does not allow the redistribution of the JDBC driver for the Structured Query Language (SQL) server 

by other vendors, such as Oracle. So, you need to download it from the Microsoft website, and install it into the

 PS_HOME\class directory.

To load and configure the Microsoft SQL Server JDBC Driver:

1. Download the Microsoft SQL Server Driver for JDBC from Microsoft.
   Note: These drivers are not used by Tuxedo or the web server, so you can ignore any comments on
2.  this site about supported versions of various web servers.
3. Save the program to disk in c:\temp or desktop.
4. Double-click the sqljdbc_<version>_enu.exe file.
5. Accept all the defaults.
   The JDBC driver files are installed in C:\program files\microsoft SQL server <ver> JDBC Driver\lib.
6. Copy these files to PS_HOME\class:
• For Microsoft SQL Server 2005 1.0/1.1/1.2 JDBC drivers copy sqljdbc.jar.
• For Microsoft SQL Server 2008 2.0/3.0 JDBC drivers copy sqljdbc.jar and sqljdbc4.jar.

Microsoft JDBC Driver for SQL Server

The Microsoft JDBC Driver for SQL Server is available to all SQL Server users at no additional charge from Microsoft. It provides access to SQL Server 2000-2014 from any Java application.

Required File(s)

sqljdbc4.jar

Default Driver Class

com.microsoft.sqlserver.jdbc.SQLServerDriver

JDBC URL Format

jdbc:sqlserver://<host>[:<port1433>];databaseName=<database>

More information and download

Microsoft

jTDS JDBC Driver

jTDS is an open source 100% pure Java (type 4) JDBC 3.0 driver for Microsoft SQL Server (6.5, 7, 2000, 2005, 2008, 2012) and Sybase (10, 11, 12, 15).

 This driver is co-packaged with DbVisualizer.

Required File(s)

jtds-1.2.5.jar

Default Driver Class

net.sourceforge.jtds.jdbc.Driver

JDBC URL Format

jdbc:jtds:sqlserver://<host>[:<port>][/<database>] 

Example:

jdbc:jtds:sqlserver://localhost:5000/myDB

jdbc:jtds:sqlserver://192.168.10.201:5000/SAMPLE

More information and download

jTDS web site

Notes

Installation Notes: Download the jtds-nn-dist.zip file, unzip it and then load the jtds.jar file in the DbVisualizer Tools->Driver Manager or in the Tools->Connection Wizard.

Page Navigation Header