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 » Working with remote servers


Create remote servers using the CREATE SERVER statement

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

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
 Example 2
 Example 3
 Example 4