title: How do I resolve using 32 bit program with 64 bit database driver?
body: <p>I'm sure some will say this questions is off topic, but it is truly about programming since I wrote this program and I need to get it working on Windows 10.</p>
  
  <p>I wrote an application in VB.Net and compiled it for "AnyCPU". So it would work in both 32 bit and 64 bit environments. The program communicates with a MySQL database so I load both the 32 bit ODBC drivers and the 64 bit ODBC drivers during the installation. However, one piece of the program uses Crystal Reports for outputting a report. The piece of Crystal I'm using only runs in the 32 bit work space.</p>
  
  <p>The MySQL database installed is 64 bit due to the 64 bit OS.</p>
  
  <p>Everything works harmoniously in Windows_7 (64 bit), but the same configuration does not work in Windows_10 (64 bit). In Windows 10 when the user tries to run the Crystal program to view a report, MySQL throws an error that it can't find the ODBC driver in </p>
  
  <p>"C:\Program Files(x86)\MYSQL\Connector ODBC 5.3\myodbc5a.dll"</p>
  
  <p>Of course the driver is there, but this error is usually due to the wrong bit version of the driver being installed. </p>
  
  <p>The 64 bit version is installed in</p>
  
  <p>"C:\Program Files\MYSQL\Connector ODBC 5.3\myodbc5a.dll"</p>
  
  <p>Is this a Windows 10 issue or something else? How can I get MySQL to use the correct driver location?</p>