Starts a local database server running from an application.
{ 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 TCPIP. See SQL Anywhere database server syntax.
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.
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=%SQLANYSAMP12%\demo.db" |
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |