DatabaseFile Connection Parameter [DBF]

Specifies the target database file for a load or connection, when starting a database.

To connect to an already running database, use the DatabaseName (DSN) parameter.

SAP Sybase IQ requires the DBF parameter and the database file name to connect under special circumstances.

Usage

Embedded databases

Values

String

Default

None

Description

DBF loads and connects to a specific database file that is not already running on a database server.

  • If a database is loaded with a name that is the same as the DatabaseFile parameter, but without the .db extension, the connection is made to that database instead.

  • If the file name does not include an extension, a file of name .db is looked for.

  • The path of the file is relative to the working directory of the database server. If you start the server from the command prompt, the working directory is the directory you are in when you enter the command. If you start the server from an icon or shortcut, it is the working directory specified in the icon or shortcut. It is recommended that you supply a complete path and file name.

  • If you specify both the database file and the database name, the database file is ignored and is not used to try to connect to a database that is already running.

You can also use UNC file names.

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

Example

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

DBF=C:\Program Files\Sybase\IQ-16_0\demo\iqdemo.db