Sybase 12.4.2 User Manual

Starting the server on Windows NT

 

This section describes methods for starting the database server that are specific 
to Windows NT systems. You can also use any of the generic methods 
described elsewhere in this chapter.

Note the server 
starting directory

Be sure to make note of what directory you are in when you start the server. 
The location of any database files you create with relative pathnames depends 
on the server startup directory. If you start the server in a different directory, 
Adaptive Server IQ looks for those database files in the new startup directory.

Any server startup scripts should change directory to a known location before 
issuing the server startup command.

The easiest way to start the server on NT is from the Start menu.

Click Start on the Task bar, and select Programs 

→

 Sybase 

→

 Adaptive Server 

IQ 12.

From here, you can start the sample database, Sybase Central, Interactive SQL, 
and the ODBC Administrator. 

You can also place databases of your own in the Program group.

You can use a Program Manager icon to hold a command line, or enter the 
following command at the system command prompt:

asiqsrv12 [ 

server-switches ] [ path\database-file [ 

database-switches ]]

You must either enter the database-file or include the servername as one of the 
server-switches.

This command starts the specified database:

•

On the specified server, if one is named in the startup command

•

On the server associated with this database, if the startup parameters 
specify a data source 

•

On the local server, if one is running and no other server is specified