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.
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.