LabSQL can not run with MySQL 64-bit ODBC connector

[SiFoo]

I have developed a small piece of LabVIEW program to retrieve the data from MySQL database and displayed as curve with XY-Graph. The bridge between database and the program is the MySQL ODBC connector and the LabSQL VIs (which is quite useful). The program runs properly in my 32-bit computer for developing while a error caused in LabSQL part and stated that there is a architecture mismatch:

------------------------------------------------------

Exception occured in Microsoft OLE DB Provider for ODBC Drivers: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application in ADO Connection Open.vi->WeatherDataRetrive.vi

------------------------------------------------------

Is there anyone encountered similar problem and would you please provide some help?

Many thanks in advance.

Harry

[rolfk]

Are you using LabVIEW 32 Bit? Even if you run on Windows 64 Bit any DLL loaded on behalve of an application has to have the bitness of that application, not the bitness of the OS. And I'm pretty sure that the ADO/DAO interface that LabSQL is using will not provide any bridging if the ODBC driver is not in the same bitness as the calling application.

So if you are using LabVIEW 32 Bit, install the 32 Bit MyODBC driver or change to using 64 Bit LabVIEW instead, although there might be other problems with ADO/DAO not working properly for a 64 Bit application.