Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 (Français) » SQL Anywhere Server - SQL Usage » Remote data and bulk operations » Accessing remote data » Troubleshooting remote data access

 

Connectivity tests

Take the following steps to be sure you can connect to a remote server:

  • Determine that you can connect to a remote server using a client tool such as Interactive SQL before configuring SQL Anywhere.

  • Perform a simple passthrough statement to a remote server to check your connectivity and remote login configuration. For example:

    FORWARD TO RemoteSA {SELECT @@version};
  • Turn on remote tracing for a trace of the interactions with remote servers. For example:

    SET OPTION cis_option = 7;

    Once you have turned on remote tracing, the tracing information appears in the database server messages window. You can log this output to a file by specifying the -o server option when you start the database server.

    For more information about the cis_option option, see cis_option option.

    For more information about the -o server option, see -o dbeng12/dbsrv12 server option.