Sybase IQ as a Data Server

Sybase IQ supports client application connections through either ODBC or JDBC. This chapter describes how to use Sybase IQ as a data server for client applications.

With certain limitations, Sybase IQ may also appear to certain client applications as an Open Server™. This chapter also briefly describes the restrictions for creating and running these applications.

See SQL Anywhere Server - Programming > Sybase Open Client support > Open Client architecture.

The facilities described in this chapter do not provide remote data access for IQ users on Windows and Sun Solaris systems. Remote data access is provided by Component Integration Services (CIS), the core interoperability feature of Enterprise Connect™ Data Access (ECDA).

• Client/Server Interfaces to Sybase IQ
  To simplify, use a Sybase application or a third-party client application with Sybase IQ.
• Sybase IQ as an Open Server
  This section describes how to set up an Sybase IQ server to receive connections from Open Client applications.
• Characteristics of Open Client and jConnect Connections
  When Sybase IQ serves applications over TDS, it automatically sets relevant database options to values that are compatible with SQL Anywhere Server default behavior. These options are set temporarily, for the duration of the connection only. The client application can override these options at any time.