Skip navigation links
MySQL Connector/ODBC Developer's Guide :: 3 Connector/ODBC Installation :: 3.1 Installing Connector/ODBC on Windows :: 3.1.2 Installing the Windows Connector/ODBC Driver Using the Zipped DLL Package
3.2 Installing Connector/ODBC on Unix »
Section Navigation      [Toggle]

3.1.2. Installing the Windows Connector/ODBC Driver Using the Zipped DLL Package

If you have downloaded the zipped DLL package:

  1. Unzip the installation files.

  2. Run the included batch file to perform an installation to the default locations.

  3. Alternatively, install the individual files required for Connector/ODBC operation manually.

Note

The following instructions only work for 32-bit Windows systems. If you have a 64-bit Windows system, use the MSI installer, which installs both the 32-bit and 64-bit drivers to the correct locations.

To install using the batch file:

  1. Unzip the Connector/ODBC zipped DLL package.

  2. Open a command prompt.

  3. Change to the directory created when you unzipped the Connector/ODBC zipped DLL package.

  4. Run Install.bat: 

    C:\> Install.bat

    This copies the necessary files into the default location, and then registers the Connector/ODBC driver with the Windows ODBC manager.

Note

Changing or adding a new DSN (data source name) may be accomplished using either the GUI, or from the command-line using myodbc-installer.exe with Connector/ODBC 5.x, or myodbc3i.exe with Connector/ODBC 3.51,

Although Oracle recommends installing these files in the standard location, you can also copy the files by hand to an alternative location - for example, to run or test different versions of the Connector/ODBC driver on the same machine. To copy the files to a location of your choice, use the following steps:

  1. Unzip the Connector/ODBC zipped DLL package.

  2. Open a command prompt.

  3. Change to the directory created when you unzipped the Connector/ODBC zipped DLL package.

  4. Copy the library files to a suitable directory. The default location is the default Windows system directory \Windows\System32: 

    C:\> copy lib\myodbc5S.dll \Windows\System32
C:\> copy lib\myodbc5S.lib \Windows\System32
If installing the Unicode-enabled driver:
C:\> copy lib\myodbc5w.dll \Windows\System32
C:\> copy lib\myodbc5w.lib \Windows\System32
If installing the ANSI driver:
C:\> copy lib\myodbc5a.dll \Windows\System32
C:\> copy lib\myodbc5a.lib \Windows\System32

  5. Copy the Connector/ODBC tools. These must be placed in a directory that is in the system %PATH%. The default is to install these into the Windows system directory \Windows\System32: 

    C:\> copy bin\myodbc3i.exe \Windows\System32
C:\> copy bin\myodbc3m.exe \Windows\System32
C:\> copy bin\myodbc3c.exe \Windows\System32

  6. Optionally, copy the help files. For these files to be accessible through the help system, they must be installed in the Windows system directory: 

    C:\> copy doc\*.hlp \Windows\System32

  7. Finally, register the Connector/ODBC driver with the ODBC manager: 

    For Unicode-enabled driver:
C:\> myodbc3i -a -d -t"MySQL ODBC 5.2 Driver;\
  DRIVER=myodbc5w.dll;SETUP=myodbc5S.dll"
For ANSI driver:
C:\> myodbc3i -a -d -t"MySQL ODBC 5.2 Driver;\
  DRIVER=myodbc5a.dll;SETUP=myodbc5S.dll"

    If you installed these files into a non-default location, change the references to the DLL files and command location in the above statement

Copyright © 1997, 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices