Need Help

  • Thread starter Thread starter Robert Lie
  • Start date Start date
R

Robert Lie

Dear All,

I want to create a program that works on my pc.
The program will read the data from .sdf file from the pocketpc and
transfer it to sql server 2000.

Pls give me some ideas how to do it?

Thanks

Robert Lie
 
Hi Robert,
I want to create a program that works on my pc.
The program will read the data from .sdf file from the pocketpc and
transfer it to sql server 2000.
Click to expand...

as far as I know, there is no application or library for the desktop
that can read sdf files. The format is simply not published IMHO.

The best approach I can see for this is to have a small application on
the PPC which uses SQL Server CE to read the data and sends it to your
desktop. Another application there listens for the data and transfers it
to SQL server.

The easiest way could be to use files; a more elegant could be to use
RAPI calls so that your two apps are directly communicating with each other.

As an alternative, you could have a webservice that the PPC calls to
upload its data.

Hope this helps,

Roland
 
Back
Top