DatabaseFile connection parameter [DBF]

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.

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 filename 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 filenames.

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