Using SQL Anywhere Database with a Web Services Server - Creating a Web Service
(Page 4 of 4 )
The Interactive SQL window can be used to create a Web Service. This service, called RedCarpet, is coded as follows. For the present do not worry about the type parameter. You can see that the authorization is taken off. The Web Service is simply accessed by calling the stored procedure.
In my Sybase Central, I have several services, one of them being RedCarpet. If you follow the list columns you will see a column heading related to URL.
In the above picture the URL Path is set to 'ON'. You do this by double clicking the Web Service in the Web Services tab, which brings up the next screen. In this screen, you can set the URL path as required. If the URL path is off you cannot access the service via URL.
When you have the URL path set to 'ON', you can access the Web Service using the URL as shown. This also verifies that the web Services server is responding to http requests. Note the port used for accessing the service and the syntax.
Summary
SQL Anywhere has a very cool interface for creating data related web services. The web server is very easy to install and work with. From USENET postings, I understand that entire websites have been created using the Web Services Server alone. Creating a web service is very easy, especially on the developer's edition that is used in this tutorial. This tutorial was tested on Windows XP Professional platform with the SQL Anywhere version 9.0.2.2451.
| DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware. |
