How to retrieve data from MySQL with Labview

[tonitp]

Hello,

Can anyone help me? I am trying to connect to a MySQL Database from LabVIEW but I don't know how to do it. I have configured correctly the ODBC drivers. Can anyone post me here a sample vi? I have done a simple example vi in LabVIEW to test the connection with my MySQL Database but an error occurs: provider error....

Thanks,

Toni.

[tonitpp]

Hello,

I have solved the problem error provider when I tried to connect MySQL with LabVIEW.

The version of MySQL ODBC 3.51 Driver (MyODBC-3.51.10-2-win.msi, version 3.51.10-2 doesn't work!!!) supplied by MySQL doesn't work with windows XP SP2 and LabVIEW 7.0.

I have downloaded earlier version of MySQL ODBC 3.51 Driver (MyODBC-3.51.10-win.msi, version 3.51.10) and it works very well, no problems.

The link for downloading the correct version is:

http://www.peterharvey.org/MySQL/MyODBC/MyODBC-3.51.10-win.msi

ToNi.