Query the version of MySQL ODB from LabVIEW

[SeanJ]

I'm communicating with a database via the MySQL ODBC driver. I must deploy the software on different computers.

On the development computer I have MySQL ODBC 5.3 and on the target computer, I have MySQL ODBC 8.0.

Is there a simple way to determine the MySQL ODBC driver version so that I can modify the connection string as needed?

[pets · Accepted solution]

Hi,

I did this once but i have only tried it on my computer, don't know if it works for others.

I have windows 10. 

/Peter

[SeanJ]

Thanks Peter, that's fantastic.

The big clue was 

WOW6432Node

i.e. access 32bit registry on 64 bit machine.  I had read value too which for some reason didn't work (-603 error).  Your solution works perfect!

P.S. In case anyone interested, the below will read the computer name (note the intentional omission of 'WOW6432Node' in the subkey constant - it gives a 603 error if it is left in).  I was confused!