Sync PPC DB to MDB on Server with XML - How?

  • Thread starter Thread starter Blaine
  • Start date Start date
B

Blaine

I've read a lot about XML, Soap, ADOCE, etc...
Now I'm really confussed.

I have a database on Pocket PC (one table).
I have an identical Table in Access (MDB) on the server.

I want to get data from server (using a query). Bring it to PPC.
I want to send data from PPC to server.

Is there anywhere that examples exist for VB.NET CF along with ASPX (or ASP
examples)?

I've done this using posts with VB6 and ASP (using doc.xml and doc.load with
a DomDocument), but I can't find a "clean" method for VB.NET CF

Any pointers / ideas / tutorials out there?

Cheers,

BL
 
use a dataset?

In one scenario, I have created a dataset on the server side, persisted it
to XML, then transmitted it to the PPC (via file sync). Then the PPC app
can open/read the dataset.
 
File Sync,

This is an interresting approach.
Can you recommend a location to find more infomration on File Syncing?
With a query I can create the XML on the server, I guess I would read it in
as as HTTP Stream, or if there are better way?

I can't seem to find any examples.... ?
 
Here's what I did:
0. insure that filesync is enabled in activesync (requires AS 3.5 or above
I think)
1. find the "briefcase path" of the last synced device.
The "briefcase path" is an activesync thing. It's stored in the
registry.
1a.
read HKCU\\Software\\Microsoft\\Windows CE Services\\Partners
if null fail (no prior sync)
read HKCU\\Software\\Microsoft\\Windows CE Services\\Last Device
if null fail (no last device)
format a key like so:
System.String.Format("HKCU\\Software\\Microsoft\\Windows CE
Services\\Partners\\{0}\\Services\\Synchronization\\Briefcase Path",
LastDevice);
read that from Registry.

That refers to a path on the local PC, the activesync "briefcase
directory". It is usually something like
c:\documents and settings\USERNAME\My Documents\PPCNAME My Documents

Where USERNAME is your username
and PPCNAME is the name of the PPC partner device.

2. Drop any file you like in that briefcase dir, or in a subdir you create
under it.

3. The next activesync will say "you have 1 file to synchronize" or
whatever.

4. It shows up on the PPC in \\My Documents\

Voila.
-D
 
Back
Top