compile for 64 bit target using MySQL ODBC

[MarkfromSAGE]

We have been developing LabView applications for several years now built ontop of a MySQL database.  We use both LV 7.1 and LV 2009.  Everything we have done so far is 32bit.  Recently, one of my users upgraded to Windows 7 64 bit, and I have been unable to make my LV applications read data from the Database.  I have tried several things, but have the following results:

1. LV Programs will run correctly when thre is no database access required.

2. My ODBC links appear to be working, as I have a fully functional HTML Program which talks to the same DB.

My development machine is a 32bit system running LV 2009 (32bit).  I have probably 100 other users which have 32 bit target machines so upgrading everything to 64bit is out of the question.  I would really prefer to not have to maintain 2 sets of applications, but if that is possible then it is better than nothing.  

Does anybody know where I should start? 

[Deborah_B]

Hello   MarkfromSAGE,

Does it throw any specific error when not reading/finding the database? Have you ever had this application run smoothly on a 64bit operating system or is this the first encounter with it? Windows can run 32-bit executables on a 64-bit PC. Therefore, the LabVIEW 32-bit Development System, Run-Time Engine, and executables can be run on Windows 64-bit, (LabVIEW 64-Bit vs. 32-Bit Applications FAQ). The fact that you're able to communicate with the Database through HTML hints that some small detail was possibly omitted in the set-up, here is the proper configuration.  I understand you've been running these for years, I just want to cover all the bases. Also checking from the Microsoft side of things, do you have the correct driver (same name but different directories) for this application?

Regards,

Deborah Y.