Configuring Adaptive Server Anywhere

Although Adaptive Server Anywhere requires no configuration to use Sybase WorkSpace for database development, you need to configure ASA to listen for web requests if you plan to utilize ASA's Web service producer.

To configure ASA to listen for web requests:

  1. Use the -xs option to specify which web protocols you want to use to listen for requests. The syntax is as follows:

    { dbeng9 | dbsrv9 } -xs {none | <web protocol> }(<parmlist;parmlist>)

  2. Because the default is none, that is, ASA does not listen for web requests, you need to specify which web protocols you want ASA to listen for and their port numbers:

    Web Protocols

    ProtocolDefault Port
    HTTP80
    HTTPS443
  3. You can add network option parameters (<parmlist>) immediately following each of the web protocols you choose. Thus, a simple configuration might look like the following example:

    dbeng9 web.db -xs http(port=80)

    You can have more than one parameter following a protocol, separated by a semicolon (no spaces between).

To establish the correct namespace for web services:

If you are using the ASA network server (dbsrv9), follow these steps to establish the correct namespace for web services:

  1. Start the server.

  2. Create a connection profile for use with your ASA server.

  3. Create a SQL file for the connection profile.

  4. Execute the following syntax in the SQL Editor:

    set option public.Webservice_namespace_host= '<hostname>:<port>'

Creating a SOAP Web Service from an ASA Stored Procedure

Starting Sybase Developer Edition Servers

See the ASA Database Administration Guide in the Adaptive Server Anywhere 9.0.2 collection under Sybase WorkSpace Server Administration

Send your feedback on this help topic to Sybase Tech Pubs: pubs@sybase.com