You only need to build Connector/ODBC from source on Windows to modify the source or installation location. If you are unsure whether to install from source, please use the binary installation detailed in Section 4.1, “Installing Connector/ODBC on Windows”.
Building Connector/ODBC from source on Windows requires a number of different tools and packages:
MDAC, Microsoft Data Access SDK from http://support.microsoft.com/kb/110093.
A suitable C++ compiler, such as Microsoft Visual C++ or the C++ compiler included with Microsoft Visual Studio 2013 or later.
The MySQL client library and include files from MySQL 5.7 or higher. This is required because Connector/ODBC uses calls and structures that do not exist in older versions of the library. To get the client library and include files, visit http://dev.mysql.com/downloads/.
Set the environment variables for the Visual Studio toolchain. Visual Studio includes a batch file to set these for you, and installs a Start menu shortcut that opens a command prompt with these variables set.
MYSQL_DIR to the MySQL server
installation path, while using the short-style file names. For
C:\> set MYSQL_DIR=C:\PROGRA~1\MySQL\MYSQLS~1.0
Build Connector/ODBC using the cmake command-line tool by executing the following from the source root directory (in a command prompt window):
C:\> cmake -G "Visual Studio 12 2013"
This produces a project file that you can open with Visual Studio, or build from the command line with either of the following commands:
C:\> devenv.com MySQL_Connector_ODBC.sln /build Release C:\> devenv.com MySQL_Connector_ODBC.sln /build RelWithDebInfo
By default, Connector/ODBC is linked statically with the MySQL
mysqlclient.lib. If you want
to link dynamically or to another MySQL client library, use the
MYSQLCLIENT_LIB_NAME option to supply the
client library's name:
C:\> cmake -G "Visual Studio 12 2013" -DMYSQLCLIENT_LIB_NAME=client_lib_name_with_extension
To compile a debug build, set the cmake build type so that the correct versions of the MySQL client libraries are used:
C:\> cmake -G "Visual Studio 12 2013" -DWITH_DEBUG=1 C:\> devenv.com MySQL_Connector_ODBC.sln /build Debug
You cannot build Connector/ODBC in debug mode and link it to the static C client library built by Oracle, which is not built with the debug options; instead, you will have to build the static client library from source with the debug options by using the same version of Visual Studio with which you compile Connector/ODBC.
For Connector/ODBC 5.3.9 and later: You can link
Connector/ODBC statically (equivalent to the /MT compiler option in
Visual Studio) or dynamically (equivalent to the /MD compiler
option in Visual Studio) to the Visual C++ runtime. The default
option is to link dynamically; if you want to link statically,
set the option
C:\> cmake -G "Visual Studio 12 2013" -DSTATIC_MSVCRT:BOOL=TRUE
By default, if you link Connector/ODBC dynamically to the Visual C++
runtime, you also need to link to a MySQL client library that is
itself linked dynamically to the Visual C++ runtime; and
similarly, linking Connector/ODBC statically to the Visual C++ runtime
requires linking to a MySQL client library that is itself linked
statically to the Visual C++ runtime. If you want to use mixed
link types, you have to use the
option to specify the Visual C++ runtime you want to link to;
cmake -G "Visual Studio 12 2013" -DMYSQLCLIENT_STATIC_LINKING:BOOL=FALSE -DSTATIC_MSVCRT:BOOL=TRUE -DWITH_NODEFAULTLIB=msvcrt
Upon completion, the executables are in the
See Section 4.1.2, “Installing the Windows Connector/ODBC Driver Using the Zipped DLL Package” on how to complete the installation by copying the binary files to the right locations and registering Connector/ODBC with the ODBC manager.