# RazorSQL

## Query, Edit, Browse, and Manage Databases

- razorsql.com
- Contact

# Sybase JDBC Driver and URL Information

Listed below are connection examples for Sybase: jTDS Driver

DRIVER CLASS: net.sourceforge.jtds.jdbc.Driver
DRIVER LOCATION: Specify the location on your machine of the jar file containing the jTDS driver.
JDBC URL FORMAT: jdbc:jtds:sybase://<host>[:<port>][/<database_name>]
Examples:
jdbc:jtds:sybase://127.0.0.1:5000/SAMPLE
Sybase Adaptive Server Enterprise JDBC Driver

DRIVER CLASS: com.sybase.jdbc2.jdbc.SybDriver
CLASS LOCATION: The Sybase installation usually includes the jConnect product. The jConnect directory structure usually contains a classes directory that houses the jconn2.jar file. This jar file can usually be used for the class location when connecting to Sybase. You may also be able to download jConnect directly from Sybase as a separate download. Consult your Sybase documentation for more information.
JDBC URL FORMAT: jdbc:sybase:Tds:<host>:<port>
There is generally no default port for Sybase, although port 7100 is used by some JDBC drivers as the default port to connect to if no port is specified for sybase. Also, port 5000 seems to sometimes be referred to as the default port for Sybase. Usually, if the default port is being used by the database server, the :<port> value of the JDBC url can be omitted.
Examples:
jdbc:sybase:Tds:neptune.acme.com:7100
jdbc:sybase:Tds:127.0.0.1:7100
Sybase Adaptive Server Anywhere JDBC Driver

DRIVER CLASS: com.sybase.jdbc2.jdbc.SybDriver
DRIVER LOCATION: The Sybase installation usually includes the jConnect product. The jConnect directory structure usually contains a classes directory that houses the jconn2.jar file. This jar file can usually be used for the class location when connecting to Sybase. You may also be able to download jConnect directly from Sybase as a separate download. Consult your Sybase documentation for more information.
JDBC URL FORMAT: jdbc:sybase:Tds:<host>:<port>?ServiceName=<database_name>
There is generally no default port for Sybase, although port 7100 is used by some JDBC drivers as the default port to connect to if no port is specified for sybase. Also, port 5000 seems to sometimes be referred to as the default port for Sybase. Usually, if the default port is being used by the database server, the :<port> value of the JDBC url can be omitted.
Examples:
jdbc:sybase:Tds:neptune.acme.com:7100?ServiceName=USER
jdbc:sybase:Tds:127.0.0.1:7100?ServiceName=USER