Hello all, I am just getting started using labSQL and MySQL and can not even connect to the database I want to practice with. I have tried to write my own code and use the example code but I can not get a connection to any database. The error is always "Exception occurred in ADODB.Connection: Operation is not allowed when the object is closed.Help Path is C:\Windows\HELP\ADO270.CHM and context 1240653 in ADO Connection Execute.vi->Simple.vi". I set up a system DSN using the MySQL ODBC 5.2 Unicode Driver and I am running Labview 2012 with MySQL 5.2 Workbench/5.6 Server. I would really just like to know the syntax of the connection string you pass into the ADO Connection Open vi. Thank you all in advance.

LabVIEW

Connection String Syntax for labSQL to MySQL

Solved!

Solution

Accepted by topic author

Author

I was finally able to get it to work by downloading the MySQL Server 5.5 (instead of 5.6) and the MySQL Connector/ODBC 5.1 (instead of 5.2). I then made the input string simply "DSN=<dsn_name>;" and I configured the DSN through C:\Windows\SysWOW64\odbcad.exe since it was a 32-bit DSN on a 64-bit machine.