ASA SQL User's Guide
Accessing Remote Data
Troubleshooting remote data access
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 Adaptive Server Anywhere.
Perform a simple passthrough statement to a remote server to check your connectivity and remote login configuration. For example:
FORWARD TO testasa {select @@version}
Turn on remote tracing for a trace of the interactions with remote servers.
SET OPTION cis_option = 7