Writing a program which accesses/manipulates a MySQL database

[RRK0280]

Hello,

I have a MySQL database which I need to be able to manipulate through Labview 8.0 on a windows machine.

I installed the MySQL ODBC 3.51 driver and created a DSN, but am unsure of how to proceed to write a program which actually accesses the db. All the examples I have downloaded have some missing files which seem to allow connection, queries, etc..., but I do not know how to get these files.

If someone could please instruct me on how to get these files or otherwise access the database I would be very grateful.

Thank you,
Rehan

[Matthew_Williams]

Michael Aivaliotis has a nice tutorial posted at:

http://www.lavag.org/archives/ON/files/Using_MySQL_with_LabVIEW.pdf

I haven't started using it myself so unfortunately this is all I can offer.

Matt

[Ankita]

Hi,

National Instruments has a LabVIEW toolkit called Database Connectivity Toolkit that makes it easy to work with databases. I am guessing that the examples you were looking at used some of the functions from this toolkit which is why you were seeing all those missing VIs.

Regards,

Ankita

[RRK0280]

Hey,

Thanks for the input. The pdf was quite useful, and I just ended up using LabSQL to connect to the databases.

Rehan