The most common method 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.
A connection to 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 System Administration Guide: Volume 1 > Sybase IQ Connections > ODBC Data Sources.