Data sources and the jConnect driver

As a general rule, the jConnect driver cannot use ODBC data sources. However, Sybase Central and Interactive SQL (Java) are special cases. When you use the jConnect driver with either of them, you can specify an ODBC data source to establish a connection.

This customized functionality is only available while you are working in Sybase Central or Interactive SQL. If you are constructing a JDBC application, do not try to use an ODBC data source to connect to a database.

StepsSpecifying a driver for the connection

  1. In Interactive SQL (Java), choose SQL > Connect to open the Connect dialog.

  2. Configure the necessary settings on the Identification and Database tabs of the log.

  3. On the Advanced tab of the dialog, select either jConnect 5 or iAnywhere JDBC Driver, or rely on the default: jConnect for Sybase Central, iAnywhere JDBC for Interactive SQL (Java).