MySQL ODBC 32 位与 64 位

MySQL ODBC 32 vs 64 bit(MySQL ODBC 32 位与 64 位)

本文介绍了MySQL ODBC 32 位与 64 位的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我有一个 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?

推荐答案

我能够

  1. 在 64 位 Windows 上安装 32 位 ODBC

  1. install ODBC 32-bit on Windows 64-bit

让我的应用程序(32 位)运行32 位 ODBC反对"64 位很好64 位 Windows 操作系统 (2008 R2) 上的 MySQL

have my application (32-bit) running fine with 32-bit ODBC "against" 64-bit MySQL on 64-bit Windows OS (2008 R2)

实现 1) 考虑到32位驱动必须安装在c:windowssyswow64.

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 rief  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%system
ul   SET installdir=%windir%system
IF EXIST %windir%system32
ul SET installdir=%windir%system32

REM ****************************
REM * check syswow64 folder too ...
REM ****************************
IF EXIST %windir%syswow64
ul 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 lib
eleasemyodbc3.lib         SET libdir=lib
elease
IF EXIST lib
elwithdebinfomyodbc3.lib  SET libdir=lib
elwithdebinfo
IF EXIST bin
eleasemyodbc3i.exe        SET bindir=bin
elease
IF EXIST bin
elwithdebinfomyodbc3i.exe SET bindir=bin
elwithdebinfo

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 "+-----------------------------------------------------+"

这篇关于MySQL ODBC 32 位与 64 位的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持编程学习网!

本文标题为:MySQL ODBC 32 位与 64 位

基础教程推荐