Testing sample programs

Before you run the sample program, do these steps:

1. Check if you can access to the Adaptive Server that is configured for remote access. To do this, log into the Adaptive Server and enter the following command:

   execute sp_configure
   

   If the Adaptive Server has already been configured for remote access, the config_value and run_value columns for the “remote access” option should be 1. If config_value is 0, enter the following command:

   execute sp_configure ‘remote access’, 1
   

2. Make sure that an entry for your Open Server name exists in the sql.ini file or the Windows registry file. Use the dsedit utility to create an entry in the sql.ini file or the Windows registry file. For more information on dsedit, see Open Client and Open Server Configuration Guide for Microsoft Windows.

3. Make sure that your Open Server name exists in the Adaptive Server’s sysservers table. To check this, log into Adaptive Server and enter the following command:

   execute sp_helpserver
   

   This command lists all the servers that are available in the Adaptive Server’s sysservers table. If the name of your Open Server does not appear in this list, enter the following command:

   execute sp_addserver your_open_server_name
   

4. Set these environment variables, if not already set:

   Environment Variable	Value
   SYBASE	Location of the Sybase home directory.
   DSLISTEN	Name of the Open Server application as listed in the sql.ini file or directory service.
   DSQUERY	Name of the Open Server as listed in the sql.ini file or directory service.