The most common way of defining an ODBC-based server is to base it on an ODBC data source. To do this, you must create a data source name (DSN) in the ODBC Administrator.
See”Defining ODBC external servers” in SQL Anywhere Server - SQL Usage.
A connection to an Sybase IQ may be as follows:
CREATE SERVER testiq
CLASS 'asaodbc'
USING 'driver=adaptive server IQ 12.0;
eng=testasaiq;dbn=iqdemo;links=tcpip{}'
For more information on creating ODBC data sources for Sybase IQ, see “Creating and editing ODBC data sources” in Chapter 3, “Sybase IQ Connections,” in the System Administration Guide: Volume 1.
