MySQL on Hand Held device

[Doug4Now]

I'm exploring the possibility of tackling a project using VB6 and MySQL. Have never used MySQL before but from what I've read it seems that it should be OK with VB6.

Down the track there is a possibility that users will require the ability to enter data via a hand-held device.

Is VB6 + MySQL + Hand-held-device a realistic combination or should I be looking at other alternatives. If so, any suggestions / advice would be warmly received.

Doug.

 

[BNPMike]

Do you mean the handheld will communicate (blootooth/802.11) with a local server or do you want the whole thing on the hand-held. Any idea what hand-held you're going to choose.

You can get things that will connect to MySQL but I've not seen a cut down version of MySQL to actually run on a hand-held.

 

[Doug4Now]

Thanks for your reply.

The most likely hand-held scenario will be a situation in which users plug into the main database and download some data onto their device - then whilst they're offsite they may (for instance) record how long they spent with particular clients and what they were doing (+ case notes etc.) and then when they return to the office upload that data to the main database - so they'll only need a portion of the main database and less functionality in the interface than users who access the main database.

I guess that I'm really just wanting to clarify that if I use MySQL/VB6 for the main database then I won't be shutting out the option to (somehow) develop hand-held functionality at a later date. I'm also looking for advice as what would be the best way to tackle that when I do come to it.

Doug.