DatabaseFile connection parameter [DBF]

Function

For use when starting a database that is not already running. The DatabaseFile connection parameter indicates which database file you want to load and connect to.

If you want to connect to an already running database, use the DatabaseName (DSN) parameter.

Sybase IQ now requires the DBF parameter and the database file name to connect under special circumstances. For details, see “Reconnecting after you restore”.

Usage

Embedded databases

Values

String

Default

There is no default setting.

See also

Chapter 1, “Running the Database Server,” Utility Guide

Description

The DatabaseFile (DBF) connection parameter is used to load and connect to a specific database file that is not already running on a database server.

You can also use UNC filenames.

WARNING! Caution The database file must be on the same machine as the database server. Managing a database file that is located on a network drive can lead to file corruption.

See also

“DatabaseName connection parameter [DBN]”

Example

To load and connect to the demo database (installed in directory C:\Program Files\Sybase\IQ-15_1\demo on Windows), use the following DBF parameter:

DBF=C:\Program Files\Sybase\IQ-15_1\demo\iqdemo.db