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.
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).
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.
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|