Pocket Access on Windows Mobile 2003 in dotnet?

  • Thread starter Thread starter Atley
  • Start date Start date
A

Atley

I want to make a database application in VB.net 2003 for my Windows Mobile
2003 PPC.

I have made an application in SQLServer CE but want this one to be simpler.

Is there a native DB that is supported? I noticed that Pocket Access is
still available in the Active$ync for my device. Is that still okay? Is
there a way to make native type DBs (like the ones for contacts?) And are
they relational or are they simply flat files that just contain one table?
(I really do not want to make a separate file for each table as i need about
ten tables for this DB).

Where do I find the methods and examples for this? I have looked in the
help for VS.net 2003 Ent Arch and cannot seem to find anything on DB's other
than Flat File (which I do not want) and SQLServer CE (which is overkill).


Thanks for the info on this, much appreciated.
 
If you don't want to use SQL CE, IntheHand's ADOCE
http://www.inthehand.com/index.php?page=5&show=1,2 is a first rate product.
You could use Straight XML Files, serializing your datasets, transferring
them at sync, then deserializing and updating accordingly. However, XML is
cool but it's not the fastest thing. I know you are hesitant to use flat
files, but if you use the www.opennetcf.org CSV library, it will take the
drudgery out of it. You could also opt for Web Services if you have network
connectivity.

HTH,

Bill
 
What happened to Pocket Access?


William Ryan eMVP said:
If you don't want to use SQL CE, IntheHand's ADOCE
http://www.inthehand.com/index.php?page=5&show=1,2 is a first rate product.
You could use Straight XML Files, serializing your datasets, transferring
them at sync, then deserializing and updating accordingly. However, XML is
cool but it's not the fastest thing. I know you are hesitant to use flat
files, but if you use the www.opennetcf.org CSV library, it will take the
drudgery out of it. You could also opt for Web Services if you have network
connectivity.

HTH,

Bill
 
What do you mean by "happened"? It's still there, there's just no managed
provider for it (likely because it's being replaced in Macallan). InTheHand
has a set of provider classes, but you can always roll your own (though if
you value your time, I'd use InTheHand's)
 
Back
Top