Running the Database as a Service

To make your repository database available to clients over the network, you should run it as a service.

  1. On the database server, select Start > Programs > SQL Anywhere 12 > Admin Tools > Sybase Central to open Sybase Central.
  2. If the Services tab is not visible, double-click the SQL Anywhere entry on the Plug-ins tab to show it.
  3. Select the Services tab, and then click the New Service tool to open the Create Service Wizard, enter a name for the service and click Next.
  4. Select Network Database Server and click Next.
  5. Accept the default executable (dbsrv12.exe) and click Next.
  6. Enter appropriate parameters separated by spaces or carriage returns and click Next. We recommend that you enter as a minimum the following parameters:
    Parameter Description
    -n servername dbfilepath [required] Specifies the server name and path to the .db file. For example:
    -n repository c:\db\repository.db
    -x tcpip(port=portno) [recommended] Specifies the port to use. For example:
    -x tcpip(port=2638)
  7. Click Next three times, accepting the remaining defaults, select Start the service now, and then click Finish.
    The database is now running and available to be connected to over the network (see Creating a Data Source to Access the Database).