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.
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, type F11 or 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 that is correct, you need only supply User ID and Password on the Identification tab. On this tab, Alt-U activates the User ID text box and Alt-P activates the Password text box.
In the DBISQL Connect dialog, you can choose the iAnywhere JDBC Driver via a radio button on the Advanced tab.
The IQ Agent can only use jConnect with JDBC to connect to a multiplex server. The jConnect JDBC drivers have been certified with multiplex and non-multiplex servers.
