I have a 32-bit application that must run on a Windows x64 server using a 64-bit version of MySQL.
Should I use a 32-bit ODBC driver or a 64-bit ODBC driver?
Or should I install a 32-bit version of MySQL too?
相关问题
- sqlyog export query result as csv
- NOT DISTINCT query in mySQL
- MySQL: conduct a basic search
- Why sometimes there is one of more gap(s) in the v
- mySQL alter table on update, current timestamp
You would need to install a 32-bit SQL and ODBC driver seeing as how your application is in 32-bit. For compatibility reasons.
I am still searching, will edit.
** EDIT
To work around this problem, use the appropriate version of the ODBC Administrator tool. If you build and then run an application as a 32-bit application on a 64-bit operating system, you must create the ODBC data source by using the ODBC Administrator tool in %windir%\SysWOW64\odbcad32.exe. To indicate the type of DSN, you can add "_32" to the 32-bit user DSNs and "_64" to the 64-bit user DSNs.
From Microsoft support.
** EDIT
If you want to have a workaround, you need to create you ODBC data source by using the Admin tool found in. This is also explained in the same link.
I was able to
install ODBC 32-bit on Windows 64-bit
have my application (32-bit) running fine with 32-bit ODBC "against" 64-bit MySQL on 64-bit Windows OS (2008 R2)
To achieve 1) I had to modify install.bat provided with the zip package of MySQL ODBC to take into account the fact that the 32-bit driver must be installed in
c:\windows\syswow64
.