A brief introduction to the Sybase Database engine operation method

1. Log on to Windows NT as an administrator.

You need Administrator privileges to create, start, and stop services.

2. Open the command prompt.

3. Use the Dbsvc utility to create a service with the following restrictions:

You must use the-a switch to specify the Sybase account and use the-p switch to specify its password.

You cannot use the-as or-i switch.

For a personal database server, the name of the executable file should be:

C:\Program Files\sybase\sql Anywhere 9\win32\dbeng9.exe

For the database server, it is:

C:\Program Files\sybase\sql Anywhere 9\win32\dbsrv9.exe

You must use the following engine parameters:

-N Engine Name

-sc

-GD DBA

-gk DBA

-GL DBA

-gu DBA

-X namedpipes (Tds=no)

4. Enter the full path to any database files that you want to run.

The path should take the database folder \ filename. db format, where the database folder is the C2 database folder, which includes all other related parameters.

For example, the following command line can create a manually initiated service named ASA_SVC and reference a network server. It runs under the Sybase account with a password of Sybase_password. It executes the following command:

C:\Program Files\Sybase\SQL Anywhere 9\win32\dbsrv9.exe -n asa_c2 -sc -gd DBA -gk DBA
-gl DBA -gu DBA -x namedpipes(TDS=NO)
database-folder\c2test.db
dbsvc -a sybase -p sybase_password -s manual
-t network -w asa_svc C:\Program Files\Sybase\
SQL Anywhere 9\win32\dbsrv9.exe -n asa_c2 -sc
-gd DBA -gk DBA -gl DBA -gu DBA
-x namedpipes(TDS=NO) database-folder\c2test.db

5. To start and stop the service, run Windows NT Service Manager from Control Panel. From the Start menu, select settings → control Panel, and then double-click Services.

The service you just created appears under adaptive Server anywhere-svc, where Svc is the name of the service that you specified on the dbsvc command line.

6. Use the "Start" and "Stop" buttons to start and stop the service.