When creating a new UltraLite database, this connection parameter names the new database file.
When opening a connection to an existing database, it indicates which database file you want to load and connect to.
SyntaxDBF=ul-db BehaviorOn connect, look to see if the database is already running. If DBN is specified, look for a matching database and connect if found, proceed to auto-start if not.
If DBF is specified, look for a matching database (identical filename) and connect if found, proceed to auto-start if not.
If neither DBN nor DBF is specified, and a single database is running, connect to it.
A database is auto-started when required if DBF is specified. If DBN is also specified, it becomes the name of the running database, otherwise a name is generated from the base filename.
RemarksBecause they are aliases, if DBF is used concurrently, the last one specified takes precedence.
If you are connecting to multiple databases on different devices from a single connection string, you can use the following parameters to name platform-specific alternates:
If specified, these platform-specific connection parameters take precedence over DBF.
The value of DBF must meet the file name requirements for the platform.
Windows Mobile If you are deploying to a Windows Mobile device, UltraLite utilities and wizards can administer an UltraLite database on an attached Windows Mobile device. To identify a file on a Windows Mobile device, you must specify the required absolute path, and use the wce:\ prefix.
Any leading or trailing spaces in parameter values are ignored. The value cannot include leading single quotes, leading double quotes, or semicolons.
See also ExamplesTo connect to the database, MyULdb.udb, installed in the desktop directory c:\mydb, use the following connection string:
"DBF=c:\mydb\MyULdb.udb" |
To connect to the same database that is deployed to the UltraLite folder of the attached Windows Mobile device, use the following connection string:
"DBF=wce:\UltraLite\MyULdb.udb" |
 |
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |