ASA Database Administration Guide
Running the Database Server
Running the server outside the current session
This section describes how to set up services using Sybase Central and the Service Creation utility.
To add a new service (Sybase Central)
In the left pane, select the Adaptive Server Anywhere plug-in.
In the right pane, click the Services tab.
Click the Add Service button in the toolbar.
Follow the instructions in the wizard.
To add a new service (Command line)
Open a command prompt.
Execute the Service Creation utility using the -w
option.
For example, to create a personal server service called myserv, which starts the specified engine with the specified parameters type the following. The engine runs as the LocalSystem user, enter the following command, all on one line:
dbsvc -as -w myserv "C:\Program Files\Sybase\SQL Anywhere 9\win32\dbeng9.exe" -n william -c 8m "C:\Program Files\Sybase\SQL Anywhere 9\sample.db"
For more information about the Service Creation utility and options, see The Service Creation utility.
Service names must be unique within the first eight characters.
If you choose to start a service automatically, it starts whenever the computer starts Windows. If you choose to start the service manually, you need to start the service from Sybase Central each time. You may want to select Disabled if you are setting up a service for future use.
Type options for the executable, without the executable name itself, in the window. For example, if you want a network server to run using the sample database with a cache size of 20 Mb and the name myserver, you would type the following in the Parameters box of the Service Creation wizard in Sybase Central:
-c 20M -n myserver c:\Program Files\Sybase\SQL Anywhere 9\asademo.db
Line breaks are optional.
For information on valid options, see the description of each program in Database Administration Utilities.
Choose the account under which the service will run: the special LocalSystem account or another user ID.
For more information about this choice, see Setting the account options.
If you want the service to be accessible from the Windows desktop, check Allow Service to Interact with Desktop. If this option is cleared, no icon or window appears on the desktop.
For more information on the configuration options, see Configuring services.