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:
Subject: DBVis ROCKS!!!
Thank you for v3.0 I have just downloaded it and it looks great. I have been using DBVis with Informix (Solaris and NT) for a year now and I have NEVER had a problem. I have been using the com.informix.jdbc.IfxDriver without a single problem.... Thank you very much...
Andrew Glover
More...