A server class specifies the access method used to interact with the server. A server class is assigned to each remote server. Different types of remote servers require different access methods. The server class provides SQL Anywhere detailed server capability information. SQL Anywhere adjusts its interaction with the remote server based on those capabilities.
There are two groups of server classes. The first is ODBC-based, and the second is JDBC-based.
The ODBC-based server classes are:
saodbc for SQL Anywhere.
aseodbc for Sybase SQL Server and Adaptive Server Enterprise (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
NoteThe JDBC classes have a significant performance impact and should only be used in situations where the ODBC classes cannot be used, for example, on NetWare. |
The JDBC-based server classes are:
sajdbc for SQL Anywhere.
asejdbc for Sybase SQL Server and Adaptive Server Enterprise (version 10 and later).
For a full description of remote server classes, see Server Classes for Remote Data Access.