You can create a remote server using a wizard in Sybase Central.
To create a remote server (Sybase Central)
Connect to the host database as a user with DBA authority.
In the left pane, double-click Remote Servers.
From the File menu, choose New » Remote Server.
The Create Remote Server Wizard appears.
In the What Do You Want To Name The New Remote Server field, type a name for the remote server, and then click Next.
Select a remote server type, and then click Next.
Select a connection type, and in the What Is The Connection Information field type the connection information:
The data access method (JDBC or ODBC) is the method used by SQL Anywhere to access the remote database. This is not related to the method used by Sybase Central to connect to your database.
Click Next.
Specify whether you want the remote server to be read-only and then click Next.
Click Create An External Login For The Current User and complete the required fields.
By default, SQL Anywhere uses the user ID and password of the current user when it connects to a remote server on behalf of that user. However, if the remote server does not have a user defined with the same user ID and password as the current user, you must create an external login. The external login assigns an alternate login name and password for the current user so that user can connect to the remote server. See CREATE EXTERNLOGIN statement.
Click Test Connection to test the remote server connection.
Click Finish.
Send feedback about this page via email or DocCommentXchange | Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0 |