ASA Database Administration Guide
  Using the Built-in Web Server

Quick start

The following procedure describes how to create a new database, start an Adaptive Anywhere Server with the HTTP server enabled, and access this database using any popular web browsers.

To set up a simple web server

1. Ensure that you have no web server already running on port 80, or choose a different port number to use for the rest of this procedure.

2. Navigate to a convenient directory and create a new database named web.

   dbinit web.db

3. Start a personal database server to run this new database. The -xs switch tells the database server to start all communication protocols, including http.

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

4. Start Interactive SQL and connect to your new database using the user id DBA and the password SQL.

5. Using Interactive SQL, execute the following SQL statement, which adds an HTML service that exposes the SYS.SYSTABLE to HTTP users. Because authorization is off, no permissions are required to access the table from a web browser.

   CREATE SERVICE tables TYPE 'HTML'
   AUTHORIZATION OFF USER DBA
   AS SELECT * FROM SYS.SYSTABLE

6. Start your favorite web browser and enter the URL http://localhost:80/tables.

Many properties of the service are controlled by parameters to the -xs command-line switch.

For more information, see Network communications parameters.

As well as starting the database server with the appropriate -xs switch parameters, you must create web services to respond to incoming requests. These are defined using the CREATE SERVICE statement.

For more information, see Creating web services and CREATE SERVICE statement.