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 (use jdbc3 for newer versions) 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 or Sybase IQ JDBC Driver DRIVER CLASS: com.sybase.jdbc2.jdbc.SybDriver (use jdbc3 for newer versions) 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> The default port for Sybase SQL Anywhere or Sybase IQ is typically 2638. Examples: jdbc:sybase:Tds:neptune.acme.com:7100?ServiceName=USER jdbc:sybase:Tds:127.0.0.1:7100?ServiceName=USER |
