Remote DB connecting and simple newb walkthroughs in WinMobile 6 SDK

[Cyprus106]

I realize how I'm going about this is somewhat odd. I have to construct a program for windows mobile that only sends a couple queries to a remote MySQL server and hopefully gets some success/fail returns.
(I've got VS2008 pro and the winmobile SDKs)

The 2 problems I have:
1) I'm very well versed in C++, and I know a little C#. I managed to compile some simple winmobile programs, but I'd be more comfortable grabbing a couple of walkthroughs or easy how-tos for relative beginners on creating winmobile apps, because I know zero in-depth. I can't seem to find ANY how-tos though. I found some videoconferences on MSDN, but that was it.

2) I know this sounds preemptive, but it's just my way of learning. I also can't find a good resource that explains connecting remotely to a server. Since this is the biggest function of the program, I'd love to find a site or page that addresses any potential issues with connectivity and how to do it. I found a little on MSDN, but it didn't help a whole lot.

If anyone could direct me to any links or any other resources I would very much appreciate it.

[markmcgookin]

Hi,

First off, don't worry about not being able too fnd stuff, you have to dig around for ages to find anything on MSDN.

I think what you are looking for is some kind of proxy stub where you have a function on your device that goes and gets a small amount of data, then the user does something that might require more data dependant on a selection, so your app then querys for that data etc....

I happen to use Nokia Intellisync to handle this kind of operation myself, but unless you want to set up a server and install intellisync mobile suite (no you don't) you need another option.

EntitySpaces have something like this you can find them here www.entityspaces.net which makes life a lot easier.

Mark

[Cyprus106]

Well I'm wondering two things: first off, I'm really looking for links for walkthroughs / how-to's that give at least SOME in-depth VC examples for winmobile.

Second, is there no native component that can connect to a remote DB? If there is, is there any sort of walkthrough or sample project or how-to that gives a little insight?

Thanks!

[markmcgookin]

Well I'm wondering two things: first off, I'm really looking for links for walkthroughs / how-to's that give at least SOME in-depth VC examples for winmobile.

Second, is there no native component that can connect to a remote DB? If there is, is there any sort of walkthrough or sample project or how-to that gives a little insight?

Thanks!

Hey,

Tolga Birdal has posted this on the codeproject.

Is that what you are looking for? This is something that a lot of experienced developers can struggle with. Remote Data Objects aren't really "newb" territory, please keep us informed of your progress so we/you can help others, and feel free to ask back if you have any more issues/questions.

Hope that helps,

Mark

[Cyprus106]

For future reference or searchers...

In the end, I followed my first inclination and simply wrote a php script and placed it on my remote server that caught POST data and uploaded it to the server. This was actually much faster (not to mention much more secure, since you're not letting just anyone hop on to your server). For the mobile side, I used WebRequests to access the php page remotely, and put the post data in a byte array. Then I simply got the datastream response and the php page, which echoed a number corresponding to a status (i.e. -1 fail 0 pass, etc.) There's quite a lot of examples & data out there on WebRequest.

Technically, all I actually did was create a really simple web service.