JDBC Driver for Microsoft SQL ServerJDBC Driver for Microsoft SQL Server

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-2016 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-2016) and Sybase (10, 11, 12, 15).

This driver is co-packaged with DbVisualizer.

Required File(s)
jtds-1.3.1.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.

Who Uses DbVisualizer

 

Customer Testimonial:
I am using dbVisualizer for over a year and I found it invaluable tool in every day work. It provides great set of advanced functionality that will please not only the database experts but novice users as well. Quality of the application is at very high level and I have had a pleasure to liaise with...
Krzysztof Slawinski
More...