Defining ODBC external servers

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.

Sybase IQ example

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.