JDBC provides a SQL interface for Java applications. Sybase Central and DBISQL can use either JDBC or ODBC. This section describes how to configure a JDBC connection for Sybase IQ. For an overview of using JDBC, see “Data Access Using JDBC” in the Sybase IQ System Administration Guide.
The jConnect driver is the default driver for the Sybase
IQ plug-in to Sybase Central. The
iAnywhere JDBC driver is the dbisql default driver.
You must specify -jconnect on the dbisql command
line to use the jConnect driver.
In order for Sybase IQ to access a server on your network using JDBC, you must supply the host name, port number, and database name when you connect.
For example, in Sybase Central, choose Connect from the Tools menu, and supply connection information. IQ supplies the host machine, port number, and database name from the last successful connection. If those are correct, you need only supply User ID and Password.
In the DBISQL Connect dialog, you can choose the iAnywhere JDBC driver using an option button on the Advanced tab.
