Setting Up Adaptive Server Enterprise

Set up Adaptive Server Enterprise for remote procedure calls (RPCs) against an access service.

Create an Adaptive Server user ID and password that matches an access service user ID and password.

See the Adatpive Server Enterprise Installation Guide for your platform to set up an Adaptive Server.

  1. Configure Adaptive Server for remote access.
    1. Log in to Adaptive Server as sa and check the current sp_configure setting:
      sp_configure 'remote access'

      • If the returned value is 1, Adaptive Server is configured for remote access.

      • If the returned value is 0, enter:
        sp_configure 'remote access',1

        Restart Adaptive Server.

  2. Define the access service as a remote server.
    1. Enter each access service name in the Adaptive Server SYSSERVERS table:
      sp_addserver service_name service_class
      where:

      • service_name is the access service to set up as a remote server.

      • service_class must be direct_connect.

      The access service name is case-sensitive and must match the name you used to define connectivity between Adaptive Server and the access service.

    2. Verify that the access service is successfully defined as a remote server: 
      sp_helpserver server_name

      This command returns a result set with a list of the services defined to Adaptive Server.

    3. Use sp_addexternlogin to add an external login password to allow access to the access services.
    4. Verify Adaptive Server/CIS connectivity using the Transaction-SQL extension connect to server_name. This is the same server name you created in a previous step using sp_addserver. This command establishes a passthrough mode connection to the access service that remains in effect until you issue a disconnect command.
    5. Enable location transparency of remote data through remote object mapping:

      • Use sp_addobjectdef to define the storage locations of remote objects.

      • Use either create table or create existing table (as applicable) to map remote table schema to Adaptive Server/CIS.

    6. Use select to perform joins across the access service after all the previous steps.

    See the Component Integration Services Guide for more information, as well as instructions for configuring and tuning Adaptive Server/CIS.

  3. Define connectivity between Adaptive Server and the access service.

    In the Windows sql.ini file or the UNIX interfaces file, add a QUERY section with the same name and ConnectionSpec that was added in step 2 (service_name).

    See the Adaptive Server Enterprise System Administration Guide and the Adaptive Server Enterprise Reference Guide.