Storing Windows CE Data

Team-Fly    

 
eMbedded Visual Basic: Windows CE and Pocket PC Mobile Applications
By Chris Tacke, Timothy Bassett
Table of Contents
Chapter 7.  Storing and Retrieving Data with ActiveX Data Objects CE


Outside of third-party products, ADOCE can access data stored in one of three places:

  • The original data store for ADOCE was the Windows CE Object Store.

  • Improved versions of ADOCE could access a Pocket Access File.

  • The introduction of ADOCE 3.1 allows access to Microsoft SQL Server CE or other OLEDBCE providers.

When designing an ADOCE application, you need to determine which data store to use. The CE Object Store choice is probably no longer desirable for an eVB application, so its discussion isn't included here.

Note

The CE Object Store limitation of requiring unique table names across applications is a good enough reason to not use it anymore. Also, the Object Store is difficult to maintain remotely, performs slower, and is more prone to corruption.


Using Pocket Access is fairly easy. A Pocket Access database is file-based , similar to the desktop version, and can exist anywhere in the file structure of a CE device. Its extension is .cdb.

There are two ways to create a Pocket Access database:

  • Use ActiveSync to create a Pocket Access database with a similar structure to a companion database on the desktop.

  • You can programmatically create a Pocket Access database through the ADOCE.Connection object.


Team-Fly    
Top
 


eMbedded Visual BasicR. WindowsR CE and Pocket PC Mobile Applications
eMbedded Visual BasicR. WindowsR CE and Pocket PC Mobile Applications
ISBN: N/A
EAN: N/A
Year: 2001
Pages: 108

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net