Server class SAODBC

A remote server with server class SAODBC is an SAP Sybase IQ database server. No special requirements exist for the configuration of an SAP Sybase IQ data source.

To access SAP Sybase IQ database servers that support multiple databases, create an ODBC data source name defining a connection to each database. Execute a CREATE SERVER statement for each of these ODBC data source names.

Example

Supply a connection string in the USING clause of the CREATE SERVER statement to connect to an SAP Sybase IQ database.

CREATE SERVER TestSA
CLASS 'SAODBC'
USING 'DRIVER=Sybase IQ;HOST=myhost;Server=TestSA;DBN=sample';