由网友(柔情小先生°)分享简介：我有一个32位的应用程序，它必须运行使用64位版本的MySQL的Windows x64服务器上。我应该使用32位的ODBC驱动程序或64位ODBC驱动程序？或者我应该安装32位版本的MySQL吗？ I have a 32-bit application that must run on a Windows x...
我有一个32位的应用程序，它必须运行使用64位版本的MySQL的Windows x64服务器上。 我应该使用32位的ODBC驱动程序或64位ODBC驱动程序？ 或者我应该安装32位版本的MySQL吗？
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?
推荐答案
我能够
在Windows上安装ODBC 32位的64位
install ODBC 32-bit on Windows 64-bit
有我的应用程序（32位）运行 细跟32位ODBC反对64位 MySQL在64位Windows操作系统（2008 R2）
have my application (32-bit) running fine with 32-bit ODBC "against" 64-bit MySQL on 64-bit Windows OS (2008 R2)
要实现1）我不得不修改提供了MySQL的ODBC的zip包INSTALL.BAT考虑到的32位驱动程序必须安装在的事实C： WINDOWS SysWow64资料。
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:windowssyswow64.
@ECHO OFF
REM #########################################################
REM
REM brief Install myodbc.
REM
REM This exists for those working with the Windows source
REM distribution.
REM
REM sa README.win
REM
REM #########################################################
SET installdir=none
IF EXIST %windir%systemnul SET installdir=%windir%system
IF EXIST %windir%system32nul SET installdir=%windir%system32
REM ****************************
REM * check syswow64 folder too ...
REM ****************************
IF EXIST %windir%syswow64nul SET installdir=%windir%syswow64
IF %installdir%==none GOTO :doError5
IF "%1"=="1" GOTO :doDebug
IF "%1"=="0" GOTO :doNormal
GOTO doSyntax
:doNormal
REM ****************************
REM * syswow64 must be specified
REM ****************************
IF EXIST %installdir%myodbc3i.exe GOTO :doError4
REM ****
REM * Find out the bin/lib directory, or use default
REM ****
SET libdir=lib
SET bindir=bin
IF EXIST libreleasemyodbc3.lib SET libdir=librelease
IF EXIST librelwithdebinfomyodbc3.lib SET libdir=librelwithdebinfo
IF EXIST binreleasemyodbc3i.exe SET bindir=binrelease
IF EXIST binrelwithdebinfomyodbc3i.exe SET bindir=binrelwithdebinfo
REM ****
REM * Copying myodbc libraries and executables to install dir...
REM ****
IF NOT EXIST %bindir%myodbc3c.exe GOTO :doError2
IF NOT EXIST %libdir%myodbc3.lib GOTO :doError2
IF NOT EXIST %libdir%myodbc3S.lib GOTO :doError2
IF NOT EXIST %bindir%myodbc3i.exe GOTO :doError2
IF NOT EXIST %bindir%myodbc3m.exe GOTO :doError2
copy %libdir%myodbc3S.dll %installdir%
copy %libdir%myodbc3S.lib %installdir%
copy %libdir%myodbc3.dll %installdir%
copy %libdir%myodbc3.lib %installdir%
copy %bindir%myodbc3i.exe %installdir%
copy %bindir%myodbc3m.exe %installdir%
copy %bindir%myodbc3c.exe %installdir%
copy doc*.hlp %installdir%
REM ****
REM * Registering driver...
REM *
REM * We can do this with myodbc3i.exe or the MS Windows ODBCConf.exe. It
REM * may be safer to use the ODBCConf.exe when we think about such things
REM * as 64bit windows.
REM ****
REM ****************************
REM * syswow64 must be specified
REM ****************************
%installdir%myodbc3i -a -d -t"MySQL ODBC 3.51 Driver;DRIVER=%installdir%myodbc3.dll;SETUP=%installdir%myodbc3S.dll"
GOTO doSuccess
:doDebug
REM ****
REM * Find out the bin/lib directory, or use default
REM ****
SET libdir=lib
IF EXIST libdebugmyodbc3d.lib SET libdir=libdebug
IF NOT EXIST %libdir%myodbc3d.lib goto doError3
IF NOT EXIST %libdir%myodbc3E.lib goto doError3
IF NOT EXIST %installdir%myodbc3i.exe goto doError1
REM ****
REM * Copying myodbc debug libraries to install dir...
REM ****
copy %libdir%myodbc3E.dll %installdir%
copy %libdir%myodbc3E.lib %installdir%
copy %libdir%myodbc3d.dll %installdir%
copy %libdir%myodbc3d.lib %installdir%
REM ****
REM * Registering driver...
REM ****
REM ****************************
REM * syswow64 must be specified
REM ****************************
%installdir%myodbc3i -a -d -t"MySQL ODBC 3.51 Driver (debug);DRIVER=myodbc3d.dll;SETUP=myodbc3E.dll"
goto doSuccess
:doSuccess
ECHO "+-----------------------------------------------------+"
ECHO "| DONE |"
ECHO "+-----------------------------------------------------+"
ECHO "| |"
ECHO "| Hopefully things went well; the Connector/ODBC |"
ECHO "| files have been copied to the system directory |"
ECHO "| and the driver has been registered. |"
ECHO "| |"
ECHO "| Connector/ODBC is ready to use. |"
ECHO "| |"
ECHO "| The most common thing to do next is to go to the |"
ECHO "| Control Panel and find the ODBC Administrator - |"
ECHO "| then use it to create a Data Source Name (DSN) |"
ECHO "| so you (and your application) can connect to a |"
ECHO "| MySQL server. |"
ECHO "| |"
ECHO "+-----------------------------------------------------+"
EXIT /B 0
:doError1
ECHO "+-----------------------------------------------------+"
ECHO "| ERROR |"
ECHO "+-----------------------------------------------------+"
ECHO "| |"
ECHO "| The non-debug version of Connector/ODBC needs to be |"
ECHO "| installed. |"
ECHO "| |"
ECHO "+-----------------------------------------------------+"
PAUSE
EXIT /B 1
:doError2
ECHO "+-----------------------------------------------------+"
ECHO "| ERROR |"
ECHO "+-----------------------------------------------------+"
ECHO "| |"
ECHO "| Connector/ODBC not built. Consider executing |"
ECHO "| Build.bat. |"
ECHO "| |"
ECHO "+-----------------------------------------------------+"
PAUSE
EXIT /B 1
:doError3
ECHO "+-----------------------------------------------------+"
ECHO "| ERROR |"
ECHO "+-----------------------------------------------------+"
ECHO "| |"
ECHO "| Connector/ODBC (debug) not built. Consider executing|"
ECHO "| Build.bat. |"
ECHO "| |"
ECHO "+-----------------------------------------------------+"
PAUSE
EXIT /B 1
:doError4
ECHO "+-----------------------------------------------------+"
ECHO "| ERROR |"
ECHO "+-----------------------------------------------------+"
ECHO "| |"
ECHO "| Existing Connector/ODBC installed. Request ignored. |"
ECHO "| |"
ECHO "+-----------------------------------------------------+"
PAUSE
EXIT /B 1
:doError5
ECHO "+-----------------------------------------------------+"
ECHO "| ERROR |"
ECHO "+-----------------------------------------------------+"
ECHO "| |"
ECHO "| Can't find the Windows system directory |"
ECHO "| |"
ECHO "+-----------------------------------------------------+"
PAUSE
EXIT /B 1
:doSyntax
ECHO "+-----------------------------------------------------+"
ECHO "| Install.bat |"
ECHO "+-----------------------------------------------------+"
ECHO "| |"
ECHO "| DESCRIPTION |"
ECHO "| |"
ECHO "| Use this to copy the driver and supporting files |"
ECHO "| to the system directory and register the driver. |"
ECHO "| |"
ECHO "| You can not properly install the debug version |"
ECHO "| without first installing the regular version. |"
ECHO "| |"
ECHO "| SYNTAX |"
ECHO "| |"
ECHO "| Install <debug> |"
ECHO "| |"
ECHO "| <debug> must be; |"
ECHO "| 0 - to install a regular build |"
ECHO "| 1 - to install a debug version |"
ECHO "| |"
ECHO "+-----------------------------------------------------+"
相关推荐
最新文章