all groups > dotnet compact framework > october 2005 >
You're in the

dotnet compact framework

group:

pocket access


pocket access Nathan Franklin
10/31/2005 12:00:00 AM
dotnet compact framework:
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

Re: pocket access Ginny Caughey [MVP]
10/31/2005 9:59:01 AM
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

--
Ginny Caughey
..NET Compact Framework MVP


[quoted text, click to view]

Re: pocket access Simon Hart
11/2/2005 2:49:01 AM
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.

[quoted text, click to view]
Re: pocket access Arun
11/2/2005 3:30:05 AM
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.
Re: pocket access Ginny Caughey [MVP]
11/2/2005 7:48:39 AM
Simon,

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

--
Ginny Caughey
..NET Compact Framework MVP


[quoted text, click to view]

AddThis Social Bookmark Button