jConnect Driver Connection Strings

To connect to a database via jConnect, you need to supply a URL for the database. For example:

Connection con = DriverManager.getConnection(
      "jdbc:sybase:Tds:localhost:2638", "<user_id>", "<password>");

The URL is composed in the following way:

jdbc:sybase:Tds:host:port

The individual components are:

• jdbc:sybase:Tds – The jConnect JDBC driver, using the TDS application protocol.
• host – The IP address or name of the computer on which the server is running. If you are establishing a same-host connection, you can use localhost, which means the computer system you are logged into.
• port – The port number on which the database server listens. The port number assigned to SAP Sybase IQ is 2638. Use that number unless there are specific reasons not to do so.

The connection string must be less than 253 characters in length.

If you are using the SAP Sybase IQ personal server, make sure to include the TCP/IP support option when starting the server.

• How to Specify a Database with a jConnect Connection String
  Each SAP Sybase IQ database server can have one or more databases loaded at a time. If the URL you supply when connecting via jConnect specifies a server, but does not specify a database, then the connection attempt is made to the default database on the server.
• Database Options Set for jConnect Connections
  When an application connects to the database using the jConnect driver, the sp_tsql_environment stored procedure is called. The sp_tsql_environment procedure sets some database options for compatibility with Adaptive Server Enterprise behavior.