Click here to Skip to main content
15,353,676 members
Articles / Mobile Apps / Windows Mobile
Posted 6 Aug 2003


40 bookmarked

A set of ADOCE classes

Rate me:
Please Sign up or sign in to vote.
4.78/5 (21 votes)
6 Aug 2003CPOL3 min read
Porting Carlos Antollini's ADO classes to the Pocket PC.

Sample Image - ado_ce_ca.jpg


One of the questions I have seen most frequently asked in Pocket PC development groups, is how to develop in eVC using ADOCE and Pocket Access. There are some resources on the web for this, but it is hard to find a freely available set of C++ classes that will encapsulate ADOCE 3.1 in complete fashion. After looking in CP, I found a very good candidate.

This article presents a port of Carlos Antollini's popular ADO classes to the Pocket PC. Carlos' article (A set of ADO Classes - version 2.07) presents a fairly thorough coverage of desktop ADO and was selected for porting because it is freely available and it is very popular.

The port

The Pocket PC uses ADOCE 3.1, a cut-down version of the ADO implementation found on desktop computers. The ADOCE 3.1 object model is smaller in both number of objects and methods. Nevertheless, it is quite usable for most database applications, retaining its ease of use.

Source compatibility

One of the objectives of this port was to keep source compatibility. Hence, you will be able to compile the source files (ado.h and ado.cpp) in both platforms: Desktop and Pocket PC. The source compatibility was achieved using precompiler directives, which may render some parts of the code harder to read.

What's missing?

Of all of Carlos' classes, the Pocket PC will only see CADODatabase and CADORecordset. In fact, these are the only classes that have direct ADOCE support. Also, not all of the classes' methods are supported and have been removed. Here is a list of the unsupported methods:

  • void CADODatabase::dump_com_error(_com_error &e);
  • BOOL CADORecordset::AddNew(CADORecordBinding &pAdoRecordBinding);
  • BOOL CADORecordset::RecordBinding(CADORecordBinding &pAdoRecordBinding);
  • CString CADORecordset::GetString(LPCTSTR lpCols, LPCTSTR lpRows, LPCTSTR lpNull, long numRows = 0);

Also, there are missing items in the CADORecordset::cadoDataType enumeration.

What's new?

During the port I had to add some missing functionalities, the most important of which is UNICODE support.

During the first debugging session I also found that CADORecordset::Open needed a new mode (openUpdate) to allow for correct use of the Update method (see sample code for an example).

Porting warnings

Check that the #import directive in ado.h is correct for your development environment.

The port has not been thoroughly tested. Please help me with this ongoing process.

Using Pocket Access

Pocket Access is a very simple database manager. It is so simple that it will not support the following (among other) desktop features:

  • Unique indexes
  • Referential integrity
  • Advanced SQL statements (almost everything is missing)
  • Autonum fields

You also have some limitations to note:

  • Maximum number of 4 indexes per table
  • Maximum of 4 tables per JOIN
  • You only get INNER JOINs

So why use it? It is very simple to setup and synchronize with your desktop environment, and you don't have to pay licensing fees.

Using ADOCE to manage your tables may be trickier than you thought, so I prepared a simple demo application that manages (does not delete - yet) a list of authors of this section. The bulk of the work is in CChildView, a CListCtrl-derived class, where records are created and modified. Please do note the peculiarities of adding new records and updating an existing record.

Sample application

The sample application is provided with full source code and with two versions of the database: desktop (.mdb) and Pocket PC (.cdb). You can create the second from the first, by using ActiveSync. If you only have an emulator to play with, you can copy the .cdb file directly into the \My Documents folder.


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

João Paulo Figueira
Software Developer (Senior) Frotcom International
Portugal Portugal
I work on R&D for Frotcom International, a company that develops web-based fleet management solutions.

Comments and Discussions

GeneralPlease help me to run your sample application Pin
AllaBry15-May-07 23:20
MemberAllaBry15-May-07 23:20 
GeneralVS 2005 Pin
AlexEvans23-Jan-07 10:53
MemberAlexEvans23-Jan-07 10:53 
GeneralRe: VS 2005 Pin
João Paulo Figueira23-Jan-07 22:06
professionalJoão Paulo Figueira23-Jan-07 22:06 
GeneralRe: VS 2005 Pin
AlexEvans23-Jan-07 23:04
MemberAlexEvans23-Jan-07 23:04 
GeneralRe: VS 2005 Pin
João Paulo Figueira23-Jan-07 23:35
professionalJoão Paulo Figueira23-Jan-07 23:35 
GeneralRe: VS 2005 Pin
AlexEvans24-Jan-07 0:47
MemberAlexEvans24-Jan-07 0:47 
GeneralRe: VS 2005 Pin
João Paulo Figueira24-Jan-07 1:19
professionalJoão Paulo Figueira24-Jan-07 1:19 
GeneralRe: VS 2005 Pin
AlexEvans24-Jan-07 9:38
MemberAlexEvans24-Jan-07 9:38 
QuestionsqlServer CE 2.0 Open recordset problem Pin
arielbiton30-Dec-06 20:42
Memberarielbiton30-Dec-06 20:42 
AnswerRe: sqlServer CE 2.0 Open recordset problem Pin
João Paulo Figueira30-Dec-06 23:07
professionalJoão Paulo Figueira30-Dec-06 23:07 
GeneralRe: sqlServer CE 2.0 Open recordset problem Pin
arielbiton31-Dec-06 1:43
Memberarielbiton31-Dec-06 1:43 
GeneralCADORecordset::Execute problem Pin
arielbiton11-Dec-06 4:33
Memberarielbiton11-Dec-06 4:33 
GeneralRecord Exists when try to add new Pin
arielbiton8-Nov-06 23:48
Memberarielbiton8-Nov-06 23:48 
GeneralRe: Record Exists when try to add new Pin
SonLusia12-Nov-06 15:48
MemberSonLusia12-Nov-06 15:48 
GeneralRe: Record Exists when try to add new Pin
arielbiton12-Nov-06 23:02
Memberarielbiton12-Nov-06 23:02 
QuestionADOCE filter shows up wrong results! Pin
ClockDivider24-Aug-06 0:23
MemberClockDivider24-Aug-06 0:23 
GeneralOpen the database Pin
Ferrante De La Grive26-May-06 8:57
MemberFerrante De La Grive26-May-06 8:57 
GeneralRe: Open the database Pin
João Paulo Figueira26-May-06 10:06
professionalJoão Paulo Figueira26-May-06 10:06 
GeneralRe: Open the database Pin
Ferrante De La Grive30-May-06 6:53
MemberFerrante De La Grive30-May-06 6:53 
GeneralRe: Open the database Pin
João Paulo Figueira30-May-06 21:53
professionalJoão Paulo Figueira30-May-06 21:53 
GeneralBOOL CADODatabase::Execute(LPCTSTR lpstrExec) problem Pin
austion8223-Mar-06 19:30
Memberaustion8223-Mar-06 19:30 
GeneralDecimal search problem !! Pin
Jae-Hyu Shin6-Feb-06 1:07
MemberJae-Hyu Shin6-Feb-06 1:07 
GeneralRe: Decimal search problem !! Pin
Ferrante De La Grive20-Jul-06 9:57
MemberFerrante De La Grive20-Jul-06 9:57 
GeneralADO Sum, Count(*) Pin
Ram Murugan17-Jan-06 21:22
MemberRam Murugan17-Jan-06 21:22 
GeneralWM5 Pin
OrkoOrko6-Jan-06 5:13
MemberOrkoOrko6-Jan-06 5:13 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.