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.
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.
Enter cd <ASE installation root> \WS-12_5\props
Backup the existing ws.properties file.
Edit ws.properties by modifying the following entries:
com.sybase.ase.ws.consumer.cisport = <an available TCP port number>
For example, com.sybase.ase.ws.consumer.cisport = 8183
com.sybase.ase.ws.consumer.logfilename = ../logs/consumer.log
com.sybase.ase.ws.interfaces = ../../ini/sql.ini
From the command prompt, enter: isql -Usa -P<password> -S<ASE server name as shown in sql.ini file>
Enable the web service feature in ASE:
sp_configure 'enable webservices', 1
Add web service server in ASE from the isql command prompt:
sp_addserver ws, sds
Install Web Service-specific stored procedure using the SQL file installws:
cd<ASE installation root>\WS-12_5\bin
isql -Usa -P<password> -S<ASE server name as in sql.ini file> -i installws
To start the ASE Web Service Consumer listener:
Type cd <ASE installation root directory>\WS-12_5\bin.
Execute runconsumer.bat.
The ASE Web Service Consumer console appears.
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