[AccessD] Access FE to SQL Server Compact BE

I had to write a program in .Net for our sale force to use in the field. It
sends us all of their invoices and then downloads all of their price lists
and customers.

I was trying to connect to an SDF while still on a Pocket PC (PPC), then
found out you couldnt do that.


I had to copy the SDF over to a directory on the users PC.

   I create the directory, if it doesnt exist on the users PC.
   Delete the SDF on the users PC, if it exists.
   Connect to the PPC
   Verify file exists on PPC
    Using rapi, I copy SDF from PPC to PC

I open the SDF and verify some records against the logged in user, then send
datasets up to a webservice.

I download the updated  customer list and price lists then send the SDF
process back to the PPC:

connect to PPC
verify file exists on PPC
rename file on PPC (to rollback in the event something goes wrong)
copy over SDF.

This whole process happens very quickly. It was a major pain to set up but
works flawless now :)

If you are doing something similar and need help, let me know.

David




On Sat, Oct 18, 2008 at 6:49 AM, Doug Steele <dbdoug at gmail.com> wrote:

> Thanks, Gustav - that's what I ended up doing, and the code worked.  Too
> bad, I was hoping to keep the installation as simple as possible.
>
> Doug
>
> On Sat, Oct 18, 2008 at 12:49 AM, Gustav Brock <gustav at cactus.dk> wrote:
>
> > Hi Doug
> >
> > Sounds like you need to run the SQL Server 2005 CE install anyway.
> > It probably does more than just registering the dll.
> >
> > /gustav
> >
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>