Configuring Client Connectivity

Sybase IQ supports ODBC and JDBC connectivity.

• Connecting Using ODBC
  Open Database Connectivity (ODBC) is a standard API that allows a single application to access a variety of data sources through ODBC–compliant drivers.
• Connecting Using JDBC
  JDBC and jConnect provide access to Sybase IQ for Java-based applications.
• Connecting Using OLE DB
  Sybase IQ includes an OLE DB provider as an alternative to ODBC.
• Connecting Using Open Client
  Clients require a server object in the interfaces file to access server properties and methods. Use the Sybase IQ Directory Services Editor (iqdsedit) to create the interfaces file entries.
• Running the Client and Server on the Same System
  Sybase IQ uses a shared memory segment and several semaphores for communication between the client and server on the same machine.
• Network Issues for Sybase IQ Servers
  Properly configured Sybase IQ UNIX servers run under the TCP/IP protocol, which enables non–UNIX clients to communicate with a UNIX database server.