4.1.1 Installing the Windows Connector/ODBC Driver Using the Zipped DLL Package

If you have downloaded the zipped DLL package:

1. Unzip the installation files to the location you want it installed.

2. Run the included batch file to perform an installation from the current directory and registers the ODBC driver.

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

4. Optionally install debug related files that are bundled in a different Zip file.

To install using the batch file:

1. Unzip the Connector/ODBC zipped Connector/ODBC package to the desired installation directory. For example, to C:\Program Files\MySQL\Connector ODBC 9.1\.

   Note

   Multiple Zip files are available: 32-bit and 64-bit, and (as of 8.0.31) a separate Debug Zip file that includes PDB files and unit tests.

2. Open a command prompt (with Admin privileges) and change the location to that directory.

3. Run Install.bat to register the Connector/ODBC driver with the Windows ODBC manager for both the ANSI and Unicode versions. Output is similar to:

   cd C:\Program Files\MySQL\Connector ODBC 9.1\
   Install.bat
   
   Registering Unicode driver
   Checking if "MySQL ODBC 9.1 Unicode Driver" is not already registered
   Registering "MySQL ODBC 9.1 Unicode Driver"
   Success: Usage count is 1
   
   Registering ANSI driver
   Checking if "MySQL ODBC 9.1 ANSI Driver" is not already registered
   Registering "MySQL ODBC 9.1 ANSI Driver"
   Success: Usage count is 1

   Note

   Install.bat assumes the default naming scheme but optionally accepts a custom name as the first parameter. For example, "Install.bat Fun" yields "Fun Unicode" and "Fun ANSI" as the driver names.

   Optionally use myodbc-installer.exe to list the registered drivers, for example:

   cd C:\Program Files\MySQL\Connector ODBC 9.1\bin
   myodbc-installer -d -l
   
   SQL Server
   MySQL ODBC 9.1 Unicode Driver 
   MySQL ODBC 9.1 ANSI Driver

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.

Using Install.bat is optional, directly using myodbc-installer.exe is an alternative option to register drivers. For example:

# For Unicode-enabled driver:
myodbc-installer -a -d -n "MySQL ODBC 9.1 Unicode Driver" -t "DRIVER=myodbc9w.dll;SETUP=myodbc9S.dll"

# For ANSI driver:
myodbc-installer -a -d -n "MySQL ODBC 9.1 ANSI Driver" -t "DRIVER=myodbc9a.dll;SETUP=myodbc9S.dll"