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. OLE DB is a data access model from Microsoft that uses the Component Object Model (COM) interfaces. Unlike ODBC, OLE DB does not assume that the data source uses a SQL query processor. Although OLE DB requires a Windows client, you can use OLE DB to access Windows and UNIX servers.
• 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. These instructions apply to sever installations only.
• 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.
• Connecting Across a Firewall
  Set the CommLinks connection parameters in your application's connection string to connect across a firewall.