Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 » SQL Anywhere Server - SQL Usage » Remote data and bulk operations » Accessing remote data


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.

The ODBC-based server classes are:

  • saodbc   for SQL Anywhere.

  • ulodbc   for UltraLite.


    You cannot create a remove server for an UltraLite database running on Mac OS X.

  • adsodbc   for Advantage Database Server.

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

  • db2odbc   for IBM DB2.

  • iqodbc   for Sybase IQ.

  • msaccessodbc   for Microsoft Access.

  • mssodbc   for Microsoft SQL Server.

  • mysqlodbc   for MySQL.

  • odbc   for all other ODBC data sources.

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


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.

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