db_start_database function

Prototype 
unsigned int db_start_database( SQLCA * sqlca, char * parms );
Arguments

  • sqlca   A pointer to a SQLCA structure. For information, see The SQL Communication Area (SQLCA).

  • parms   A null-terminated string containing a semicolon-delimited list of parameter settings, each of the form KEYWORD=value. For example: 
    "UID=DBA;PWD=sql;DBF=c:\\db\\mydatabase.db"

For a list of connection parameters, see Connection parameters.

Description

The database is started on an existing server, if possible. Otherwise, a new server is started. The steps carried out to start a database are described in Locating a database server.

If the database was already running or was successfully started, the return value is true (non-zero) and SQLCODE is set to 0. Error information is returned in the SQLCA.

If a user ID and password are supplied in the parameters, they are ignored.

The permission required to start and stop a database is set on the server command line. For information, see -gd server option.

Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0