pocket access

[Nathan Franklin]

hey guys, i think i have decided upon using pocket access.

it is just for a simple app with simple sql queries ( nothing more then
inner joins )

my question is, how do i add the database into activesync so it sync with
every sync operation..

i need to know how to do it programatically, could someone please help me..

also am I likeley to run into any problems using pocket access, it is for a
relativly small app not exceed 65000 records...

its a slow db isnt it? thats ok i guess, but i dont think i need to go to
the trouble of installing sql server ce, and then msde on the desktop and
also configuiring iis for replication.. etc.. etc.. blah blah especially
when this all has to be automated!!

thanks heaps dudes

kind regards
nath

 

[Ginny Caughey [MVP]]

nath,

The biggest problem with Pocket Access is that it isn't available on Windows
Mobile 5.0. The second biggest problem is speed. Both SqlCE and SQL Mobile
are faster, and SQL Mobile is certainly the best choice if you are using CF
2.0. The biggest problem with the SQL products is that you can't use
Activesync to just sync them (although merge replication and RDA are options
for syncing with SQL Server), so you'll need a 3rd party product like one of
these:

www.gui-innovations.com
www.primeworks.pt

 

[Guest]

Hi,

Pocket Access does suck bigtime, avoid. I find SQLCE2.0 performance good on
CF1.0.

Is SQL Mobile the next version of SQLCE?

Regards
Simon.

 

[Arun]

Simon,

SQL Mobile is the next version of SQL CE 2.0
Take a look at this
http://www.microsoft.com/sql/ce/mobility/beta1.mspx

Cheers,
Arun.

 

[Ginny Caughey [MVP]]

Simon,

As Arun says, yes. It's been completely rewritten for performance and
features.