connecting labview7 with mysql

[NGOE]

Hi, am working wiith labview 7 student edition. I need to connect to mysql database server but I cant because I do not have labview connectivity toolkit compartible with this varsion. does anyone have the connectivity toolkit to assist me?

[Dennis_Knutson]

You don't need the toolkit in order to connect to a database. There is LabSQL and see the code from Mike Porter here.

[NGOE]

Thanks for your advice but I have tried to install labSQL and its not going tho' instead it alerts me that its not compartible.

[RDR]

I downloaded the .zip file from this link in the post by Dennis.  Inside of the zip file there are VIs which I have opened in LabVIEW 7.0 without any issues.  What error are you receiving?

-Bob

[mikeporter]

What exactly does the error message say? Also, you will need ODBC or ADO (OLE DB) drivers for mySQL.

Mike...

[Haydon Ge]

hi, Currently our solving problem is based on Mysql3.51 version, I have no idea about the higher version of mysql. but 3.51 works.... First. You need download 3.51 mysql driver second, the format of command to Labsql is Driver={MySQL ODBC 3.51 Driver};Server=your romote pc ip;Port=3306;Database=your database;User=your name; Password=your password;Option=3;