Data exchange between CE device and desktop PC

Hi,

we have some applications for Pocket PC that collect data in CE
databases. On the desktop PC we have applications that prepare the
databases and retrieve the data after sampling. We did this via RAPI and
it works wonderful (until CE 5) and it was very easy for the users of
our software.

With CE 5 RAPI became "bad" and with CE 6 the CE databases will not be
supported anymore. AFAIK there is no possibility for RAPI to read data
from and write into SQL server CE and/or the new EDB. A data exchange
based on file transfer is not a real alternative for us.

How did you exchange your data? Is there anywhere any useful
information? I read a lot of stuff at MS -- about IIS etc. -- but it was
really hard to understand that. (In other words: I didn't understood
much.) Additionaly our PC solution is not an C# or C/C++ application but
it is made with Smalltalk. It is not really a problem to use a DLL under
Smalltalk, but it is not just include and link.

Every usefull hint is welcome.

--
Claus

Yaroslav
Tue Apr 04 02:01:15 CDT 2006

You can implement a module on the device side that will work with your
device database and communicate with the desktop. You can use CeRapiInvoke
to execute a dll on the device and IRAPIStream to transfer data between
desktop and device.

--
Yaroslav Goncharov
Spb Software House, http://spbsoftwarehouse.com
Pocket PC Developer Network, http://pocketpcdn.com


"Claus Henning" <claus#minus#guntram#dot#henning#at#ortim#dot#de> wrote in
message news:OKSLTN7VGHA.4416@TK2MSFTNGP15.phx.gbl...
> Hi,
>
> we have some applications for Pocket PC that collect data in CE databases.
> On the desktop PC we have applications that prepare the databases and
> retrieve the data after sampling. We did this via RAPI and it works
> wonderful (until CE 5) and it was very easy for the users of our software.
>
> With CE 5 RAPI became "bad" and with CE 6 the CE databases will not be
> supported anymore. AFAIK there is no possibility for RAPI to read data
> from and write into SQL server CE and/or the new EDB. A data exchange
> based on file transfer is not a real alternative for us.
>
> How did you exchange your data? Is there anywhere any useful information?
> I read a lot of stuff at MS -- about IIS etc. -- but it was really hard to
> understand that. (In other words: I didn't understood much.) Additionaly
> our PC solution is not an C# or C/C++ application but it is made with
> Smalltalk. It is not really a problem to use a DLL under Smalltalk, but it
> is not just include and link.
>
> Every usefull hint is welcome.
>
> --
> Claus

MiroB
Tue Apr 04 03:03:04 CDT 2006

RAPI is n't problem, but definition of IRAPIStream for SmallTalk or Delphi ?
(I use Delphi and can't continue becuause of IRAPIStream definition.
IRAPIStream.h translation to pas version does not exists.
IRAPIStream.h code is too extensive & complicated. )

Miro


"Yaroslav Goncharov" <yaroslav@softspb.com> pí¹e v diskusním pøíspìvku
news:O71bSW7VGHA.4900@TK2MSFTNGP12.phx.gbl...
> You can implement a module on the device side that will work with your
> device database and communicate with the desktop. You can use CeRapiInvoke
> to execute a dll on the device and IRAPIStream to transfer data between
> desktop and device.
>
> --
> Yaroslav Goncharov
> Spb Software House, http://spbsoftwarehouse.com
> Pocket PC Developer Network, http://pocketpcdn.com
>
>
> "Claus Henning" <claus#minus#guntram#dot#henning#at#ortim#dot#de> wrote in
> message news:OKSLTN7VGHA.4416@TK2MSFTNGP15.phx.gbl...
>> Hi,
>>
>> we have some applications for Pocket PC that collect data in CE
>> databases. On the desktop PC we have applications that prepare the
>> databases and retrieve the data after sampling. We did this via RAPI and
>> it works wonderful (until CE 5) and it was very easy for the users of our
>> software.
>>
>> With CE 5 RAPI became "bad" and with CE 6 the CE databases will not be
>> supported anymore. AFAIK there is no possibility for RAPI to read data
>> from and write into SQL server CE and/or the new EDB. A data exchange
>> based on file transfer is not a real alternative for us.
>>
>> How did you exchange your data? Is there anywhere any useful information?
>> I read a lot of stuff at MS -- about IIS etc. -- but it was really hard
>> to understand that. (In other words: I didn't understood much.)
>> Additionaly our PC solution is not an C# or C/C++ application but it is
>> made with Smalltalk. It is not really a problem to use a DLL under
>> Smalltalk, but it is not just include and link.
>>
>> Every usefull hint is welcome.
>>
>> --
>> Claus
>
>

r_z_aret
Tue Apr 04 17:11:53 CDT 2006

On Tue, 04 Apr 2006 08:45:41 +0200, Claus Henning
<claus#minus#guntram#dot#henning#at#ortim#dot#de> wrote:


clip


>
>How did you exchange your data? Is there anywhere any useful

We use text files on the handhelds, and a desktop transfer program
that translates between our text files and whatever database is in the
back end. We are planning to change to SQLite as our "native" database
for handheld and backend, with desktop tools to go from SQLite to
whatever databases our customers use.

clip

>
>Every usefull hint is welcome.

-----------------------------------------
To reply to me, remove the underscores (_) from my email address (and please indicate which newsgroup and message).

Robert E. Zaret, eMVP
PenFact, Inc.
20 Park Plaza, Suite 478
Boston, MA 02116
www.penfact.com