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.

Embedded databases

String

There is no default setting.

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.

• 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.

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

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