Specifying a driver for your connection

When you work with a database, all your requests and commands go through a driver to the database itself. Interactive SQL and Sybase Central support two main JDBC drivers: Sybase jConnect™, and the iAnywhere JDBC Driver. Both are included with Sybase IQ.

By default, the Sybase Central IQ plug-in and Interactive SQL (Java) use the iAnywhere JDBC Driver. It provides JDBC 2.0 support and fully scrollable cursors, which the jConnect 5.5 driver does not. jConnect is still useful for zero footprint applications such as Web pages.

For more information on JDBC drivers including required software, see “Choosing a JDBC driver” and “Using the jConnect JDBC Driver” in SQL Anywhere Server – Programming and “Working with ODBC data sources”.