How to start a process on the desktop from the Pocket PC?

[orandov]

Hi,

I am new to programming with a hand held. I am working with Pocket PC
2003, .NET 1.1, SQL Server 2000, SQLCE 2.0.


I am using merge replication to sync the data between my SQLCE and
SQL
2000 database. After the sync I want to start a process on the
desktop
that will take the rows from one of the replicated tables and change
the data and insert it into a different table.


I think I can use a database trigger (I have never actually used one)
to handle the process, but I was told by my superviser that I am not
allowed to use a trigger.


I can create a vb.net app on the desktop to handle this process but
how do I start the vb on the desktop from my hand held?


Thank you,


Oran

 

[orandov]

Ok, so nobody responded to my original post probably b/c this has been
posted several times in this group. So I did a little digging and I
found some very helpful posts (which I have used) by many people
including: Chris Tacke, Peter Foot and others.

But...I still need some help.

This is what I need to do:

1) Synchronize the CE database when they place pocket pc in the
cradle.
2) Then AFTER the databses have been synched, I want to run a desktop
application to process the data in the SQL server database.

So what I did was...

1) Use the CERunAppAtEvent on the NOTIFICATION_EVENT_RS232_DETECTED to
fire off a pocket pc application that synchronizes the CE database to
the Desktop.
2) Then I used the Registry Based Notification (AutoStartOnConnect) to
register my desktop application with active sync to be fired off when
a connection is detected.

Both of these steps worked on there own but the problem is that the
synchronization of the CE Databse takes about 30 seconds - 1 minute
and the desktop application gets fired off b/f the databases haved
synched up.

How can I fix this? Did I miss a step?

Can I fire the desktop app from my pocket pc app using:
"CreateProcess("AppName", "", IntPtr.Zero, IntPtr.Zero, 0, 0,
IntPtr.Zero, IntPtr.Zero, si, pi)"? I tried that but it didn't work.
Do I need to register the app on the ppc?

Sorry if there is a simple solution. I am new to handhelds and using
the registry (and I guess .NET )

Oran

 

[Guest]

No, as it would present a gigantic security hole. The simplest mechanism is
to auto-start a desktop app that creates a socket to the device app and then
listens for a "Done" message on that socket.


--

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

 

[orandov]

Thank you for responding, Chris.

That sounds good but, I have never used the Socket class. Can you
point me to any examples of creating a socket to a pocket pc?

Oran