Documentation Home
MySQL Connector/ODBC Developer Guide
Related Documentation Download this Manual

MySQL Connector/ODBC Developer Guide  /  ...  /  Installing the Windows Connector/ODBC Driver Using the Zipped DLL Package

4.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.

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:

    For Connector/ODBC 8.x:

    C:\> copy lib\myodbc8S.dll \Windows\System32
    C:\> copy lib\myodbc8S.lib \Windows\System32
    
    If installing the Unicode-enabled driver:
    C:\> copy lib\myodbc8w.dll \Windows\System32
    C:\> copy lib\myodbc8w.lib \Windows\System32
    
    If installing the ANSI driver:
    C:\> copy lib\myodbc8a.dll \Windows\System32
    C:\> copy lib\myodbc8a.lib \Windows\System32

    For Connector/ODBC 5.x:

    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\myodbc-installer.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 Connector/ODBC 8.x:

    For Unicode-enabled driver:
    C:\> myodbc-installer -a -d -t"MySQL ODBC 8.0 Driver;\
      DRIVER=myodbc8w.dll;SETUP=myodbc8S.dll"
    
    For ANSI driver:
    C:\> myodbc-installer -a -d -t"MySQL ODBC 8.0 Driver;\
      DRIVER=myodbc8a.dll;SETUP=myodbc8S.dll"

    For Connector/ODBC 5.3:

    For Unicode-enabled driver:
    C:\> myodbc-installer -a -d -t"MySQL ODBC 5.3 Driver;\
      DRIVER=myodbc5w.dll;SETUP=myodbcS.dll"
    
    For ANSI driver:
    C:\> myodbc-installer -a -d -t"MySQL ODBC 5.3 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


User Comments
User comments in this section are, as the name implies, provided by MySQL users. The MySQL documentation team is not responsible for, nor do they endorse, any of the information provided here.
Sign Up Login You must be logged in to post a comment.