Use the CREATE SERVER statement to set up remote server definitions. To use Sybase Central to create remote server definitions, see Create remote servers using Sybase Central.

For ODBC connections, each remote server corresponds to an ODBC data source. For some systems, including SQL Anywhere, each data source describes a database, so a separate remote server definition is needed for each database.

You must have RESOURCE authority to create a remote server.

On Unix platforms, you need to reference the ODBC driver manager as well.

For a full description of the CREATE SERVER statement, see CREATE SERVER statement.

Example 1

The following statement creates an entry in the ISYSSERVER system table for the Adaptive Server Enterprise server called RemoteASE:

CREATE SERVER RemoteASE
CLASS 'ASEJDBC'
USING 'rimu:6666';

Example 2

The following statement creates an entry in the ISYSSERVER system table for the ODBC-based SQL Anywhere server named RemoteSA:

CREATE SERVER RemoteSA
CLASS 'SAODBC'
USING 'test4';

Example 3

On Unix platforms, the following statement creates an entry in the ISYSSERVER system table for the ODBC-based SQL Anywhere server named RemoteSA:

CREATE SERVER RemoteSA
CLASS 'SAODBC'
USING 'driver=SQL Anywhere 11;dsn=my_sa_dsn';

Example 4

On Unix platforms the following statement creates an entry in the ISYSSERVER system table for the ODBC-based Adaptive Server Enterprise server named RemoteASE:

CREATE SERVER RemoteASE
CLASS 'ASEODBC'
USING '/opt/sybase/ase_odbc_1500/DataAccess/ODBC/lib/libsybdrvodb.so;dsn=my_ase_dsn';