Any suggestions on how to interface a PC and a handheld to share data?

[jamie]

I'm hoping there is a simple solution to this issue that I just haven't
seen.

Basically what I have is a handheld has all data stored in a sqlCE database.
I need to take that data to a PC and work with it.

So since I can't move an sqlCE database I need to turn it into XML and then
move the XML file. This all works nicely if I do it manually.

The issue comes up when I want to run it all from the PC without ever
touching the handheld.

So I can use RAPI to tell the handheld to generate the XML file. Thats
easy but How can I tell that the XML is finished being built?

If I just use RAPI to build the call a program to build the file and then I
use another rapi call to move the file back to the pc right away it may be
copying a partially built file.

So then I thought about adding a status file and a loop to know when the
file is finished building but this starts to turn into a nightmare of loop
timers rapi calls.

Basically I think I need to be able to recieve a remote event over the
wireless network. Is this possible? Am I looking at this all wrong?

 

[Paul G. Tobey [eMVP]]

There are too many possible ways to tell that the XML has been built: have
the process that builds it create a file, separate from the XML file, when
it's done, and have the PC delete that file when it has retrieved the XML
completely or something (as you may have been thinking).

Have the handheld open a socket and send a message, possibly including the
XML data.

Have the PC run a Web service and have the handheld send the data to that
service.

Have the handheld connect to an FTP or Web server running on the PC and send
the file to that when it's done.

Paul T.

 

[David D Webb]

With SQL Everywhere, you can use the SQL Mobile file directly on the PC.

http://www.microsoft.com/sql/CTP_sqlserver2005everywhereedition.mspx

-Dave