Configuring Client Connectivity

SAP 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 SAP Sybase IQ for Java-based applications.
• Connecting Using OLE DB
  SAP 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 SAP Sybase IQ Directory Services Editor (dsedit) to create the interfaces file entries.
• Running the Client and Server On the Same System
  SAP Sybase IQ uses a shared memory segment and several semaphores for communication between the client and server on the same machine.
• Network Issues for SAP Sybase IQ Servers
  Properly configured UNIX servers run under the TCP/IP protocol, which enables non–UNIX clients to communicate with the server.