Sybase Database Engine running methods

1. log on to Windows NT as Administrator.

You need the Administrator permission to create, start, and stop services.

2. Open the command prompt.

3. Use the dbsvc utility to create a service. The restrictions are as follows:

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

You cannot use the-as or-I switch.

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

C: \ Program Files \ Sybase \ SQL Anywhere 9 \ win32 \ dbeng9.exe

For database servers:

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 of any database file to be run.

The path should be in the format of database Folder \ file name. db, where the database folder is the C2 database folder, including all other related parameters.

For example, the following command line can create a manually started service named asa_svc and reference a network server. It runs under the sybase account, and its password is sybase_password. It executes the following commands:

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 the control panel ". from the "Start" menu, select "Settings" → "Control Panel", and double-click "service ".

The newly created Service appears under Adaptive Server Anywhere-svc, where svc is the service name you specified on the dbsvc command line.

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

1. Sybase data backup-BCP usage Overview
2. Popularity of Sybase SQL Server logs
3. How to port a database from Sybase to SQL Server