ODBC-based Server Classes

Sybase IQ supports a variety of ODBC-based server classes.

See SQL Anywhere Server - SQL Usage > Remote data and bulk operations > Server classes for remote data access > ODBC-based server classes.

• ODBC External Servers
  The most common method of defining an ODBC-based server is to base it on an ODBC data source.
• Server Class saodbc
  To access SQL Anywhere database servers that support multiple databases, create an ODBC data source name defining a connection to each database. Issue a CREATE SERVER statement for each of these ODBC data source names.
• Server Class aseodbc
  Sybase IQ requires the local installation of the Adaptive Server Enterprise ODBC driver and Open Client connectivity libraries to connect to a remote Adaptive Server Enterprise with class aseodbc. However, the performance is better than with the asejdbc class.
• Server Class db2odbc
  A server with server class db2odbc is IBM DB2.
• Server Class oraodbc
  A server using server class oraodbc is Oracle version 10.0 or higher.
• Server Class mssodbc
  A server with server class mssodbc is Microsoft SQL Server version 6.5, Service Pack 4.
• Server Class odbc
  ODBC data sources that do not have their own server class use server class odbc. You can use any ODBC driver.