Re: Access Sync service

Thanks for the information, it will definitely come in handy.

I might look at RDA with Access, and it's great that I don't have to use IIS.

I was gonna use ADS, and that still might be a viable option.

The last option was Sync Services which I just downloaded. At least I think I did. I'm not sure if I just got the Books OnLine, but I was gonna try that out even though it is still in Beta 2.

I'll go back and look at ADS and see if I can't read some more on it. I just bought some books on Mobile .NET Development and a book on the Compact Edition. I'll see if any of these have a section on ADS.

Thanks!
Tom

"Laxmi Narsimha Rao ORUGANTI MSFT" <Laxmi Narsimha Rao ORUGANTI MSFT@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:49FBC51F-528E-40E8-8BD5-C10DAE147CEA@xxxxxxxxxxxxxxxx
Hey Tom,

Pardon me for jumping in so late.

RDA with SQL Server - IIS is required
RDA with Access - IIS is NOT required

ADS (Access Database Synchronizer) or SWA (Sync With Access) comes with
a
HTTP Listner which is sufficient enought for RDA with Access.

Please note that ADS is meant to sync SQL CE on DEVICE with Access on
DESKTOP.

The moment you cradle it, HTTP Listner starts running. To make sure the
communication happens smoothly, you may need to open the port for HTTP
Listner packet reception port (its not port 80) but some ephemeeral range
port number.

Please use MSDN forum as we will watch that closely.

Thanks,
Laxmi



"Tom Holmes Jr." wrote:

Never mind .... I just read in another message that the Access Data
Syncronizer and RDS both use IIS.
Damn It!

You'd think Microsoft would be much farther along in along us to sync data
between their Access or SQL Server with the storage unit on the device. Do
they really want us to use IIS??????????????????? A major-gaping security
hole you could drive the Queen Mary
through????????????????????????????????????????????????????????????

All the bad memories of Microsoft Development from 10 years ago are starting
to re-surface ....
nice to know that some things never change.

"Tom Holmes Jr." <tom@xxxxxxxxxxxxx> wrote in message
news:ep0ZUYZwHHA.4572@xxxxxxxxxxxxxxxxxxxxxxx
>I downloaded the access sync service and installed it. This is the >tool
>that allows us to sync data between the SQL Server Compact Edition (SDF
>file) on the device to the Access database on the PDA. I even >installed
>the sample cab file on the PDA correctly. Lastly, there are some ssce
>tools I had to download and install ... which I did.
>
> The readme.doc which I have several times says that I should go to
> programs-> start -> and then execute the Sample Application Wizard or
> something like that. There is nothing I can find that would be a link > to
> that program.
>
> What am I missing or what file should I run to configure this sync?
> thanks!
>
> Tom



.

Relevant Pages

  • Re: Speeding up the RDA Push and Pull
    ... in the dial-up connection, the device, the IIS box or SQL Server. ... Try doing the sync on a device that has PPC 03 on it. ... Determine where the databsae and temporary database files are located. ... If you are doing large syncs with RDA, you might find better perofrmance by ...
    (microsoft.public.sqlserver.ce)
  • support: on / off sync issues
    ... whenever I make a change in the IIS console and or restart the IIS ... all the phones switch their settings from their usual sync ... cause the phones to set themselves to "manually sync". ... defaultwebsite - intergrated windows auth + basic auth ...
    (microsoft.public.pocketpc)
  • Speeding up the RDA Push and Pull
    ... RDA Pull and Push to sync the data between the PPC and the Central Server.We ...
    (microsoft.public.sqlserver.ce)
  • Re: manual installation of sqlce server agent on iis 6.0
    ... Configuring IIS Manually for Replication and RDA ... SQL Server CE v2.0 Agent must be specified as part of the ...
    (microsoft.public.sqlserver.ce)
  • Re: Activesync Push GPRS Single Server with OWA
    ... Finally we found that we have a n URL SCAN ISAPI filter on the IIS ... We removed that filter and tested the PDA ... Your Account does not have permissions to sync with your current settings. ...
    (microsoft.public.pocketpc.activesync)