Sybase Connection Help

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