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.
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|