Contents Index Connecting to a database on your own machine from Sybase Central or Interactive SQL Connecting using a data source

ASA Database Administration Guide
  Connecting to a Database
    Simple connection examples

Connecting to an embedded database


An embedded database, designed for use by a single application, runs on the same machine as the application and is largely hidden from the application user.

When an application uses an embedded database, the personal server is generally not running when the application connects. In this case, you can start the database using the connection string, and by specifying the database file in the DatabaseFile (DBF) parameter of the connection string.

Using the DBF parameter 

The DatabaseFile (DBF) parameter specifies which database file to use. The database file automatically loads onto the default server, or starts a server if none are running.

The database unloads when there are no more connections to the database (generally when the application that started the connection disconnects). If the connection started the server, it stops once the database unloads.

The following connection parameters show how to load the sample database as an embedded database:

dbf=path\asademo.db
uid=DBA
pwd=SQL

where path is the name of your Adaptive Server Anywhere installation directory.

Using the StartLine [Start] parameter 

The following connection parameters show how you can customize the startup of the sample database as an embedded database. This is useful if you wish to use options, such as the cache size:

Start=dbeng9 -c 8M
dbf=path\asademo.db
uid=DBA
pwd=SQL

See also


Contents Index Connecting to a database on your own machine from Sybase Central or Interactive SQL Connecting using a data source