User's Guide

Part III. Using SQL Anywhere

Chapter 29. Running Programs as Services

This section describes how to add and remove SQL Anywhere services.

Adding a SQL Anywhere service

You may wish to set up services for one or more of the SQL Anywhere programs that can be run as a service. This section describes how to set up services using Sybase Central.

To add a new SQL Anywhere service:

1. In Sybase Central, open the Services folder.
2. Double-click Add Service. The Service Creation Wizard is displayed..
3. Follow the instructions in the wizard to define the service you are creating:
   • Select the type service you wish to create.
   • Enter a name for the service. Service Names must be unique within the first eight characters.
   • Choose whether you wish the service to start automatically (that is, whenever the computer starts NT), manually (you need to start the service from Sybase Central each time), or if you want the service disabled. You may want to select Disabled if you are setting up a service for future use.
   • Specify the name and complete path of the executable you wish to run as a service.
   • Enter a set of command-line switches for the executable to use in the Parameters box. For example, if you wish a network server to run using the sample database with a cache size of 20Mb, and a name of myserver, you would enter the following in the Parameters box:

          -c 20M
          -n myserver c:\sqlany50.sademo.db
     

     Line breaks are optional. For information on valid command-line switches, see the description of each program in the chapter "SQL Anywhere Components".

   • 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 NT desktop, check Allow Service to Interact with Desktop. If this option is unchecked, no icon or window appears on the desktop.

  For more information on the configuration options, see "Configuring SQL Anywhere services".

Removing a SQL Anywhere service

Removing a SQL Anywhere service removes the server name from the list of services. Removing a SQL Anywhere service does not remove any SQL Anywhere software from your hard disk.

If you wish to re-install a SQL Anywhere service that you have removed, you will need to reenter the command-line switches.

To remove a SQL Anywhere service:

1. In Sybase Central, open the Services folder.
2. Right-click the icon of the service you wish to start, and select Delete from the popup menu