ODBC External Servers

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.

See SQL Anywhere 11.0.1 > SQL Anywhere Server - SQL Usage > Remote Data and Bulk Operations > Server classes for remote data access > ODBC-based server classes > Defining ODBC external servers.

Sybase IQ example

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.