Embedded Visual Basic Windows Ce And Pocket Pc Mobile Applications [Electronic resources] نسخه متنی

Storing Windows CE Data

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.