StartLine (START) connection parameter

{ StartLine | START }=local-database-server-command

Embedded databases

local-database-server-command By default, SQL Anywhere attempts to connect to a running database server. If no server can be found with the specified connection parameters, SQL Anywhere automatically starts a new local database server using the local-database-server-command. The database server is not started automatically if the HOST connection parameter is specified or the CommLinks (LINKS) parameter includes TCP/IP. See The SQL Anywhere database server.

dbeng12 on all platforms except for Windows Mobile.

dbsrv12 on Windows Mobile.

The StartLine connection parameter is only used to start a database server if a connection cannot be made to the specified database server.

For example, suppose you start a database server running a database as follows:

dbeng12 c:\mydb.db

Connect another database (without specifying a database server name using the Server connection parameter):

dbisql -c "START=dbsrv12 -x none -c 8M;DBN=seconddb;DBF=c:\myseconddb.db;UID=DBA;PWD=sql"

In this case, the dbsrv12 database server is not started. Instead, the dbeng12 database server that was used to start mydb.db is used to start and connect to myseconddb.db.

However, if Server=server-name had been specified, and a database server named server-name was not running, then the dbsrv12 database server would have started.

Note

If you want to specify the database name, database file, or server, it is recommended that you use the DBN, DBF, and Server connection parameters, rather than the StartLine connection parameter.

The following command uses the recommended syntax:

START=dbeng12 -c 8M;Server=mydb;DBN=mydb;DBF=c:\sample.db

The following syntax is not recommended:

START=dbeng12 -c 8M -n mydb "c:\sample.db"

The following data source fragment starts a personal database server with a cache of 8 MB.

StartLine=dbeng12 -c 8M;DBF=samples-dir\demo.db

For information about samples-dir, see Samples directory.

StartLine (START) connection parameter

Syntax

Usage

Allowed values

Default

Remarks

Note

See also

Example