Monday, March 12, 2012

how to sync mobile database and ms-access database?

Hi,
i am working with windows mobile Cf 2.0 and desktop. i got problem when i were trying to synd mobile database and ms-access database.
my requirement is online i want to transfar data records from mobile to desktop vice versa.
but how? i dont knwo any body would like to guide me.
i am ready to accepting yours valuable views.
waiting
bye
Rajat.maybe you should have a look at the ADS Wizard http://www.microsoft.com/downloads/details.aspx?FamilyId=B967347A-5DD0-445C-8A9F-AEA3DB9EC4BC&displaylang=en|||Hi,
i make more clear, what actualy i want to do.
i want to access mobile databse (.sdf) from desktop application which is build in .net.
or
i want to access desktop access databse (.mdb) from mobile application which is build in .net.
mobile may be pocket or smart phone.
thanks for all efforts
bye
Rajat|||

Access device database from desktop:

1. Copy SDF file from device to desktop using, say, RAPI.

2. Access this copy from desktop application.

3. Copy changed database back to device.

Access Jet database (which you call “Access”) from device:

1. Create Web Service to expose Jet database remotely.

2. Access this web service from device.

|||Hi thanks for concering,
i have tryed copying approch from device to desktop but i thing it is not systematic work.
i send u a link there say it can possible which we are discusing but i can not able to understand.
please take a look the link;

Pocket PC with SQL CE - The Code Project - .NET Compact Framework

may be it will help u to make that which i want and i am tring reqularly.
good luck you and myself also.
bye|||Ilya, do you have any tips on how to do this? I have an existing program that worked this way using cdb files and DESKTOPTODEVICE/DEVICETODESKTOP APIs. With our latest batch of iPAQs that come preloaded with Windows Mobile 5, I am unable to use our existing system and must rewrite our program. I'd like to keep the webservice as is and only change the local desktop calls to the mobile device.

Are there any links that you can provide (or sample code) for Steps 1, 2 & 3 when using sdf files and I assume SqlServerCe ?

Thank you,
David
|||hi,
i have made a dll which makes connection between M to D/ D to M.
but i dont know how to send it.
give me right way to send the file to you by the mail.
bye
keep connecting.|||you can zip & email it to

rocndav at hotmail dot com

Thank you,
David
|||Well I was able to get mine to work by using RAPI commands to copy the sdf file to my desktop and then use CE31 runtime to be able to read the sdf file. I was able to communicate with my existing web service.

These links really helps me out, hopefully this saves the next person some time:

Rapi sample:
http://msdn2.microsoft.com/en-us/library/ms837846.aspx

SQLCE 3.1:
http://blogs.msdn.com/mgaur/archive/2007/01/16/sql-server-compact-edition-3-1-launched.aspx

No comments:

Post a Comment