Server classes

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.

  • ulodbc   for UltraLite.

  • aseodbc   for Sybase SQL Server and Adaptive Server Enterprise (version 10 and later).

  • adsodbc   for Advantage Database Server.

  • db2odbc   for IBM DB2.

  • mssodbc   for Microsoft SQL Server.

  • oraodbc   for Oracle servers (version 8.0 and later).

  • mysqlodbc   for MySQL.

  • msaccessodbc   for Microsoft Access.

  • odbc   for all other ODBC data sources.

Note

When using remote data access, if you use an ODBC driver that does not support Unicode, then character set conversion is not performed on data coming from that ODBC driver.

The JDBC-based server classes are:

  • sajdbc   for SQL Anywhere.

  • asejdbc   for Sybase SQL Server and Adaptive Server Enterprise (version 10 and later).

Note

The JDBC classes have a significant performance impact and should only be used in situations where the ODBC classes cannot be used.

For a full description of remote server classes, see Server classes for remote data access.