Databases & DriversDatabases & Drivers

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

This driver is co-packaged with DbVisualizer.

Required File(s)
jtds-1.2.2.jar

Default Driver Class
net.sourceforge.jtds.jdbc.Driver

JDBC URL Format
jdbc:jtds:sybase://<host>[:<port>][/<database>]

Example:
jdbc:jdtds:sybase://localhost:5000/myDB
jdbc:jdtds:sybase://192.168.10.201:5000/SAMPLE

More information and download
http://jtds.sourceforge.net/

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.

jConnect for JDBC

jConnect provides high performance native access to the complete family of Sybase products including Adaptive Server Enterprise, Adaptive Server Anywhere, Adaptive Server IQ, and Replication Server.

Required File(s)
jconn3.jar

Default Driver Class
com.sybase.jdbc3.jdbc.SybDriver

JDBC URL Format
jdbc:sybase:Tds:<host>:<port2048>/<database>

Example:
jdbc:sybase:Tds:10.0.0.2:2048
jdbc:sybase:Tds:mupp:5000/dbvistest

More information and download
Sybase

Notes
The jConnect JDBC driver is usually delivered as zip file. First you need to unzip this file and locate then jconn3.jar file which usually is stored in the classes directory. In DbVisualizer make sure you load this jconn3.jar file.