Setting Up ASE Web Service Consumer

If you want to use the ASE Web Service Consumer feature, the Web Services feature must be installed, and ASE must be properly configured.

Note

The default ASE Page size is 2K, to use WebService feature, page size must be at least 4K.

To configure ASE for a web service 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

Creating an ASE Web Service Consumer

Web Services User's Guide, Part 2, "Configuration"

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