Appendix A Setting Up the Adaptive Server Anywhere Database Server as a Service

Why use the Adaptive Server Anywhere server?

The Adaptive Server Anywhere personal server has a limit of ten connections. While this limit is appropriate for developing a Web site, it is not sufficient for a "live" site that will get any number of calls at one time. Every request from a browser counts as one connection. For example, a Web page containing three graphics and one OLE control can generate five connections to the database.

Comparison of the personal server and the network server

Personal database server	Network server
No network connection	Network connections
Ten-connection limit	Connection limit based on license
Can run as an NT service	Can run as an NT service
Can be automatically started through ODBC	Cannot automatically start a remote server ODBC
Can be automatically started if set up as a service	Can be automatically started if set up as a service
Can be automatically stopped	Cannot be automatically stopped

For more information on running Adaptive Server Anywhere, see the Adaptive Server Anywhere documentation.

Check your license agreement
You must confirm that you are properly licensed to use PowerDynamo and Adaptive Server Anywhere before using your Web site.

Why run the Adaptive Server Anywhere database server as a service?

There are several advantages to running the Adaptive Server Anywhere database server as a service for PowerDynamo:

Users can log out of NT without connections being lost or losing their own connection to the server.
The server console is secure as users must use normal NT security to log in.
A new user logging in will already be set up with both the database server and the Web server as they both run as a service.
Users can log in and out of NT while the database server continues to run and accept connections.
A service can be configured to start automatically when the NT computer is started, before a user logs on.