Re: Access Database Synchronizer (ADS)

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Answer #1:

Device Emulator is included with Visual Studio 2005 then I installed the
Windows Mobile 6.0 Professional SDK. That comes with some emulator images
that you can load and cradle from Device Emulator.

I remember only seeing one CAB file in the ADS folder.


Answer #2:

I used the "sqlce.access.sample.PPC.wce5.armv4i.cab" and it worked perfectly
on Windows XP SP2. I also tried debugging through the included sample source
code and everything seems to be in place


Answer #3:

Use the System.mdw that is under the Documents and Settings\<Username that
you login with>\......\System.mdw


Answer #4:

Which one wants a username? I don't think I understand what you mean. I
don't recall anywhere in the mobile application sample where it asks for a
Username.


Special Note:

1. The Desktop URL should be the MACHINE NAME, accessing the IP address
directly won't work.
2. Remember to add an exception to your firewall allowing port 1024
3. Verify in your desktop's browser that the service is running and
configured ok, if you enter the desktop URL in your browser (e.g.
http://christian:1024/) then it should display "Microsoft SQL Server Compact
Edition Server Agent". If this text is not displayed, then ADS is not
running properly on the desktop

--
Regards,
Christian Resma Helle
http://christian-helle.blogspot.com


"Lhunt" <Lhunt@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:243A187B-772B-43A0-93E1-A7F6501C8994@xxxxxxxxxxxxxxxx

Thank you for your reply.

Question #1. Where did you get the wm6 emulator for Vista?

I have both Vista and XP but want to get XP up first.

There are two cab files:
sqlce.access.sample.PPC.wce5.armv4i.cab and
sqlce31.access~~.cab

Question #2. I have tried both, which one worked for you?

Question #3. One wants the path to system.mdw (I have about 5
system.mdw)
files, which one?

Question #4. One wants the User Name. Which user name, the one I log
onto
Windows with?

The documentation is complete enough to make you think you can figure it
out, but with 2 files (I can't tell which is newer) and different
variables,
it gets nuts.

Thanks again for your and anyone elses HELP.




"Christian Resma Helle" wrote:

I have no problems with the ADS on a WM5 and WM6 device connected to a XP
SP2 desktop. My problems are only getting it to work on Vista on an
actual
device. I managed to get it to work on Vista using the device emulator,
but
when i try with an actual device then it just won't succeed.

I have openned a support case with Microsoft and after talking to them
(the
SQL Server support) for 3 hours they decided that they have to transfer
the
case to the Windows CE team, which i have a feeling will transfer me to
the
Vista team, which will probably transfer me back to the SQL server
team...
and so on...

I'll post updates when something interesting finally happens.

--
Regards,
Christian Resma Helle
http://christian-helle.blogspot.com


"Lhunt" <Lhunt@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:93F3112A-451A-4709-95C9-C7BE4D7B04A9@xxxxxxxxxxxxxxxx
Thanks for the Link.

As I have invested so much time on the Access Database Synchronizer,
downloaded every imaginable file to upgrde, turned off all my
firewalls,
using Windows 5 machine and XP sp2 desktop and have it 98% working, is
there
any one who has the exact steps or variables to put in on the
configuration
to make it work so I can figure out the 'Unspecified Error
[sqlcea30.dll]'
error connecting to Access database. Do the developers at Microsoft
ever
test their stuff on real machines?

Has ANYONE, ANYWHERE ever got this thing to Actually WORK. I can't
think
of
anything else to try.

"Ginny Caughey [MVP]" wrote:

I don't mind sharing my code, but it's very specialized to the apps
that
use
and I haven't taken the time to prepare it for general use. (It also
does
data validation and manipulation as well as extracting the subset of
data
I
need to download.) A nice Rapi wrapper is available at
http://www.opennetcf.com/FreeSoftware/DesktopCommunication/tabid/90/Default.aspx

--
Ginny Caughey
Device Application Development MVP


"Lhunt" <Lhunt@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8996DE72-86EC-4649-9619-D036DB7D02C1@xxxxxxxxxxxxxxxx
I am having the exact same issue. Drives me crazy how much time I
have
spent
because the code is incomplete or the documentation is not detailed
enough.

Do you have PPC and/or Desktop code you have written to do the RAPI
that
you
would be willing to share.

I have spent hours and hours on this, and everyone seems to say the
same
thing but never any solutions.

"Ginny Caughey [MVP]" wrote:

Tom,

It might seem like a kludge, but it's something you can count on to
work
since you'll control all the code for it including what you do with
any
potential errors or data conflicts that might occur along the way.
The
same
app that uses Rapi to copy the sdf file to the desktop can do the
updates,
and it can even delete the sdf file on the desktop when it's
finished.
There
might be a few moving parts involved, but I'm pretty sure all the
other
sync
solutions have them too only you can't see them.

Once Sync Services supports mobile devices, I think it will offer a
nice
alternative approach, and I admit I'm also disappointed the mobile
pieces
aren't in place yet. I still think it's well worth downloading and
exploring
though as it gives you a sense how it will all work.

--
Ginny Caughey
Device Application Development MVP


"Tom Holmes Jr." <tom@xxxxxxxxxxxxx> wrote in message
news:e4IQL4k6HHA.1168@xxxxxxxxxxxxxxxxxxxxxxx
Hi Ginny,

I think that having to copy the SDF file to the desktop,
maniupulate
it,
and then write it back up ... IMHO ... is clunky, has way too
many
moving
parts, and can break leaving the process in a bad state. It's a
workaround for an obvious existing problem.

I spent a day or two installing on the Compact Edition tools,
SDK's,
tools, etc. for Visual Studio .NET 2005 on my Vista laptop ...

Bill has suggested Sync Services ... but in Beta2, you can't use
it
on
devices yet. It would have been nice to know that before I
installed
and
started reading the docs.
It was also suggested that I use ADS .... but I think everyone
should
know
that you can't use ADS if the Access database is going to be on a
Vista
machine unless you're using WM 6.0. That was the first thing I
read
with
the docs. The HTTP listener can't, won't start on Vista, I get
an
Access
denied error. All my research shows that this is a known issue
and
one
of
the ADS developers said in April 2007 that they are working on a
fix
..........

So, now I have my XP developement laptop using ActiveSync 4.5,
and I
had
to re-download all the tools for VS.NET 2005. I even installed
ADS,
and
NOW ....
I can see and test that the HTTP listner IS running correctly
when I
hook-up the PDA to the cradle. And it stops accordingly when I
disconnect
the PDA.
Now, for some stupid reason my ADS is broken on the PDA ... so I
stopped
it and re-installed it.

Maybe I will use your solution as a last resort ......

"Ginny Caughey [MVP]" <ginny.caughey.online@xxxxxxxxxxxxxx> wrote
in
message
news:A27F3342-8E16-446B-9A78-643806D87F1C@xxxxxxxxxxxxxxxx
Tom,

Many of us with simple sync requriements just write our own.
It's
not
that hard. I've found the easiest way to do it is to copy the
sdf
file
from the device to the desktop using Rapi, then once you're on a
desktop
it's pretty easy to write a desktop app that can read/write to
both
the
sdf file and any other database you like.

I'm not sure what your problems are with the Access sync since
none
of
my
apps use Access and instead sync with SQL Server data.

--
Ginny Caughey
Device Application Development MVP


"Tom Holmes Jr." <tom@xxxxxxxxxxxxx> wrote in message
news:ufyjEMe6HHA.3400@xxxxxxxxxxxxxxxxxxxxxxx
Amazing ..... Sync Services in it's current start ....
according
to
it's
documentation doesn't work on devices now??????

Second, ADS doesn't work with WM 5.0 with Vista .....
WTF?????????????????

I'm getting really frustrated now .......

"Tom Holmes Jr." <tom@xxxxxxxxxxxxx> wrote in message
news:esiXItC6HHA.2312@xxxxxxxxxxxxxxxxxxxxxxx
I have a Windows Vista Home Edition with Visual Studio .NET
Prof.
Edition.
I have a Dell Axim with Windows Mobile 5.0.
The laptop holds my Access database and the PDA has my SDF
(SQL
Compact
Edition) file, and I will be using
Access Database Synchronizer (I think) to Synchronize between.
ADS
is
installed and I have the ADS Wizard on my PDA.

I CAN connect to the SDF file on the PDA, that works fine.
I can NOT connect to the Access database file. I do have port
1024
open on the Vista firewall.

I suppose I could test to make sure I can access the HTTP
Listener
on
the desktop from the PDA.
Open the browser on the PDA, and point to:
http://machinename:1024
right?

In the meantime I can't pull/push data ... I presume I have to
have
the
ADS Wizard talking to both databases first?

I will go back over the ADS Readme.doc ... but I will ask here
anyway
...
1) Can I open to an Access database that is secured with a
username
and
password?
I see an option for the SDW file ... is that all I need?
Let's presume the Access database is not secured .... do I
need
to
put
anything into that last box of the ADS Wizard?

2) There are some lists I want to push to the PDA from the
laptop
...
ones for lookups.
There are also some tables that I want partial data (some
records)
to
push to the PDA ... can I do that?
Can I filter a table so that only some records from a data
table
go
to
the PDA.

3) Likewise, there are some tables that I want to push the
records
from
the PDA to the Desktop.
Can those records get deleted when they are pushed?
If we only pull some records to a PDA and some records to
another
PDA
... when the desktop/laptop Access database gets updated,
there
shouldn't be any conflict resolution.

4) There are no tables that I know of currently that need to
be
synced
... that is a copy of a table needs to match exactly on both
sides
...
the laptop and the PDA.

Thanks very much!
Tom











.

Relevant Pages

  • Re: Access Database Synchronizer (ADS)
    ... I have both Vista and XP but want to get XP up first. ... As I have invested so much time on the Access Database Synchronizer, ... It was also suggested that I use ADS ... hook-up the PDA to the cradle. ...
    (microsoft.public.sqlserver.ce)
  • Re: Access Database Synchronizer (ADS)
    ... I have no problems with the ADS on a WM5 and WM6 device connected to a XP ... As I have invested so much time on the Access Database Synchronizer, ... and it can even delete the sdf file on the desktop when it's finished. ... hook-up the PDA to the cradle. ...
    (microsoft.public.sqlserver.ce)
  • Re: Access Database Synchronizer (ADS)
    ... I don't mind sharing my code, but it's very specialized to the apps that use and I haven't taken the time to prepare it for general use. ... > that you can't use ADS if the Access database is going to be on a Vista ... > hook-up the PDA to the cradle. ...
    (microsoft.public.sqlserver.ce)
  • Re: Access Database Synchronizer (ADS)
    ... and it can even delete the sdf file on the desktop when it's finished. ... It was also suggested that I use ADS ... hook-up the PDA to the cradle. ... The laptop holds my Access database and the PDA has my SDF (SQL Compact ...
    (microsoft.public.sqlserver.ce)
  • Re: Access Database Synchronizer (ADS)
    ... The same app that uses Rapi to copy the sdf file to the desktop can do the updates, and it can even delete the sdf file on the desktop when it's finished. ... It was also suggested that I use ADS ... but I think everyone should know that you can't use ADS if the Access database is going to be on a Vista machine unless you're using WM 6.0. ... I can see and test that the HTTP listner IS running correctly when I hook-up the PDA to the cradle. ...
    (microsoft.public.sqlserver.ce)