Set Database File Property

You can use setProperty to specify the database file name on the device, such as the directory of the running program, a specific directory path, or a secure digital (SD) card.

ConnectionProfile cp = SUP101DB.GetConnectionProfile();
cp.SetProperty("databaseFile", "sup101.udb");
cp.Save();

Examples

The databaseFile is created in the /Temp directory of the Windows Mobile device:
/Temp/mydb.udb
The databaseFile is created on an SD card:
"/Storage Card/mydb.udb"
Note: For the database file path and name, the forward slash (/) is required as the path delimiter, for example /smartcard/supprj.db.

Usage

  • Be sure to call this API before the database is created..
  • The database is UltraLiteā„¢; use a database file name like mydb.udb.
  • For DOE applications, the database is SQLite; use a database file name like mydb.db.
  • If the device client user changes the file name, he or she must make sure the input file name is a valid name and path on the client side.
Note: Sybase recommends using industrial grade SD cards using Single Level Cell (SLC) technology. SD cards that use SLC technology are generally more reliable and faster than MLC cards, although they may be more limited in size and more expensive per unit of storage. Not all SD cards perform equally, and it is advised that customers evaluate the benchmarks available from different suppliers.