Oracle

[JB]

I am looking at writing an app for use on WM5/6 devices, ordinarily I
would use SQL Mobile on the PDA, SQL Server 2000 on the server and
then either merge replication (or adapter.update or just a bunch of
SQL scripts) to transfer data back and forth between PDA and server.

I now need to explore using Oracle, can anyone tell me what the
possibilities are here?
i) Is there an Oracle database for PDAs,
ii) Is there a merge replication equivalent,
iii) Where can I find some example code on using Oracle on a PDA and
also doing some kind of merge relication process with Oracle at both
ends?

Thanks for any advice.

 

[chris-s]

I am looking at writing an app for use on WM5/6 devices, ordinarily I
would use SQL Mobile on the PDA, SQL Server 2000 on the server and
then either merge replication (or adapter.update or just a bunch of
SQL scripts) to transfer data back and forth between PDA and server.

I now need to explore using Oracle, can anyone tell me what the
possibilities are here?
i) Is there an Oracle database for PDAs,
ii) Is there a merge replication equivalent,
iii) Where can I find some example code on using Oracle on a PDA and
also doing some kind of merge relication process with Oracle at both
ends?

Thanks for any advice.

Visit Oracle's website.

Chris

 

[JB]

Wow that's useful advice, it may be no supprise to you that I have
already visited Oracle's site.

Maybe I was not being especially thorough, maybe I just missed the
information I was looking for, but either way I couldn't find the
information I wanted.

Can anyone else provide some useful insight?

 

[Doug Bell]

Joseph,
We have been using Mobile devices as scanners for stock transfer for a
couple of years connected to a BPCS system (DB2).
The way we originally tackled it was to transfer some XML files with the
data whenever the device was docked and then had a Dot Net App running on
the receiving PCs that periodically looking for any XML files. It
de-serialised the data then matched it to the existing records in the
database, constructed an full record and uploaded it to BPCS.

While it has been adequate, we are currently looking for a better solution.

Doug