Accessing mySQL database from Labview PDA

[azimi3]

Hi,

Has anyone tried writing data to a mySQL database or any other database for that matter using the Labview PDA module?  I know it's easy to do from Labview and you have to download the ODBC drivers to get it working but I don't think these drivers are available for Windows Mobile (I've seen XP and Linux drivers only).  Any help would be appreciated.

Thanks

[JLS]

Hello,

I don't have experience with this, but you might look into the following:

1. remote connections: http://www.geekzone.co.nz/content.asp?contentid=2656

2. this thread seems to indicate .NET doesn't support it yet (but it's over a year old...): http://forums.mysql.com/read.php?38,73109,73109

3. Another option - you can use VI Server to have your PDA VI call a VI on your host machine if they are networked... there is an example of this that ships with LabVIEW PDA I think - check it out!  Thus, if the db is on your host machine, you could write your host VI, and have your PDA VI call it etc.

I hope this helps!

Best Regards,

JLS

[azimi3]

Thanks for the response.  I like your last idea which made me think of something else.  I can probably just have the PDA use TCP/IP to transmit data to a PC running a Labview App which is designed to receive this data and then write it to the mySQL database.  This might be the easiest solution right now even though it is tedious.  Thanks again for your help.