ASA SQL User's Guide
Accessing Remote Data
Basic concepts to access remote data
A server class is assigned to each remote server. The server class specifies the access method used to interact with the server. Different types of remote servers require different access methods. The server classes provide Adaptive Server Anywhere detailed server capability information. Adaptive Server Anywhere adjusts its interaction with the remote server based on those capabilities.
There are currently two groups of server classes. The first is JDBC-based; the second is ODBC-based.
The JDBC-based server classes are:
asajdbc for Adaptive Server Anywhere (version 6 and later)
asejdbc for Adaptive Server Enterprise and SQL Server (version 10 and later)
The ODBC-based server classes are:
asaodbc for Adaptive Server Anywhere (version 5.5 and later)
aseodbc for Adaptive Server Enterprise and SQL Server (version 10 and later)
db2odbc for IBM DB2
mssodbc for Microsoft SQL Server
oraodbc for Oracle servers (version 8.0 and later)
odbc for all other ODBC data sources
For a full description of remote server classes, see Server Classes for Remote Data Access.