File System

[Rick]

How would one go about programmatically accessing the file system on a
PPC from a desktop app if the PPC is connected via ActiveSync. I need
to be able to copy files to it and modify an SQLCE database from the
desktop app.

Rick

 

[Fabien]

Hi,

For the files, you can use RAPI and for SQL database, you can try SQL
merge replication.

Fabien Decret (Device Application Development MVP)
Windows Embedded Consultant

ADENEO (ADESET)
http://www.adeneo.adetelgroup.com/ | http://fabdecret.blogspot.com/

 

[Rick]

Ok, I think RAPI is exactly what I need. As for SQL merge
replication, I don't think this is it at all. I need to be able to do
complex operations on the database. I'd ideally be able to work with
the database like any other database.

Rick

 

[Guest]

You'll have to write or acquire some form of proxy then. RAPI can give you
the ability to send commands from the desktop to the device, but it has
nothing for SQL CE, so you'll need to write some device-side component that
takes in commands and returns results and then attach to it in some way
(RAPI would work, but I'd be more inclined to use a socket).


--

Chris Tacke, Embedded MVP
OpenNETCF Consulting
Managed Code in an Embedded World
www.OpenNETCF.com

 

[chris-s]

What about using SQL 2005 Compact Edition, would this provide a
database that can be utilised by both a desktop and a mobile
application? I guess you are still stuck with exactly how your desktop
top app would connect to the actual sdf file tho.

Chris

 

[Guest]

When I said SQL CE I was thinking SQL Compact Edition. Sure, the file can
be used on either side, and one could pull the entire file and then make
modifications, but that's goinf to be really ugly if the database is live or
if's a few hundred MB in size. The solution is not hard. Create some small
app that takes commands through a socket and sends back results. Use RAPI
to push it to the device and start it. Done.


--

Chris Tacke, Embedded MVP
OpenNETCF Consulting
Managed Code in an Embedded World
www.OpenNETCF.com