Enabling the ASE Web Service Consumer

If you want to use the ASE Web Services Consumer feature, the Web Services feature must be installed, and ASE must be properly configured. You can configure Adaptive Server Enterprise manually or with the ASE Features Enabling wizard.

Note

The default ASE Page size is 2K. To use the Web Services feature, the page size must be at least 4K.

Use the following procedure to manually enable the Web Services Consumer.

  1. Enter cd <ASE installation root> \WS-12_5\props

  2. Backup the existing ws.properties file.

  3. Edit ws.properties by modifying the following entries:

    1. com.sybase.ase.ws.consumer.cisport = <an available TCP port number>

      For example, com.sybase.ase.ws.consumer.cisport = 8183

    2. com.sybase.ase.ws.consumer.logfilename = ../logs/consumer.log

    3. com.sybase.ase.ws.interfaces = ../../ini/sql.ini

  4. From the command prompt, enter: isql -Usa -P<password> -S<ASE server name as shown in sql.ini file>

    1. Enable the web service feature in ASE:

      sp_configure 'enable webservices', 1

    2. Add web service server in ASE from the isql command prompt:

      sp_addserver ws, sds

  5. Install Web Service-specific stored procedure using the SQL file installws:

    1. cd<ASE installation root>\WS-12_5\bin

    2. isql -Usa -P<password> -S<ASE server name as in sql.ini file> -i installws

To start the ASE Web Service Consumer listener:

Creating an ASE Web Service Consumer

See the Web Services User's Guide, Part 2, "Configuration" on the Sybase WorkSpace bookshelf.

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