Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 » UltraLite - Database Management and Reference » UltraLite Database Reference » UltraLite connection parameters


UltraLite CE_FILE connection parameter

Names the new database file when creating a database. When opening a connection to an existing database, this connection parameter identifies the database.


  • DBF connection parameter.

  • If you do not set a value for the DBF connection parameter or this connection parameter, then the default value is \UltraLiteDB\ulstore.udb.


You should use the CE_FILE connection parameter for UltraLite client applications that use the same connection string to connect to a Microsoft Windows Mobile device, and other platforms.

The CE_FILE connection parameter takes precedence over the DBF connection parameter. If you are connecting from an UltraLite administration tool, or your connection object only connects to a Windows Mobile database, use the DBF connection parameter.

The value of CE_FILE must meet the file name requirements for Windows Mobile. If you include an absolute path to the database, then all directories must exist before setting the path to this file. UltraLite does not create them automatically.

Any leading or trailing spaces in parameter values are ignored. This connection parameter's value cannot include leading single quotes, leading double quotes, or semicolons.

See also

The following example creates a new connection and identifies different database files for the Windows desktop and Windows Mobile platforms:

Set Connection = DatabaseMgr.OpenConnection("DBF=d:\Dbfile.udb;CE_FILE=\myapp\MyDB.udb")