This error is thrown because the 64-bit version of odbcad32.exe
, the ODBC Data Source Administrator program, was used to configure the Data Source Name (DSN) to the database when the 32-bit version of the ODBC Data Source Administrator program should have been used.
First, be sure of having the 32-bit version of MySQL
installed. There will be two different files named odbcad32.exe
on Windows 7 x64. Even though both are named odbcad32.exe
, one is 64-bit and the other is 32-bit. You can tell which is 64-bit and which is 32-bit by their directory location:
- 64-bit version is in <Windows>/SysWOW64
- 32-bit version is in <Windows>/System32
There are two options to correct the error:
- Fix the ODBC setup. To do this, open the 64-bit version of odbcad32.exe, delete the database configuration, then open the 32-bit version as an Administrator and configure the database there.
- Change your LabVIEW or LabWindows/CVI code to use the UDL with the exact connection string. You can learn more about this in How Do I Set Up a Microsoft Data Link File (UDL) Through LabVIEW?