Remote servers

Before you can map remote objects to a local proxy table, you must define the remote server where the remote object is located. When you define a remote server, the server's class must be chosen.

A server class specifies the access method used to interact with the 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 server classes are:

SAODBC for SQL Anywhere.
ULODBC for UltraLite.

Note

You cannot create a remote server for an UltraLite database running on Mac OS X.
ADSODBC for Advantage Database Server.
ASEODBC for Sybase Adaptive Server Enterprise (version 10 and later).
DB2ODBC for IBM DB2.
HANAODBC for SAP HANA.
IQODBC for SAP Sybase IQ.
MSACCESSODBC for Microsoft Access.
MSSODBC for Microsoft SQL Server.
MYSQLODBC for Oracle MySQL.
ODBC for all other ODBC data sources.
ORAODBC for Oracle Database servers (version 8.0 and later).

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.

When you define a remote server, an entry is added to the ISYSSERVER system table for the remote server.

Remote servers

Note

Note

See also