Differences

This shows you the differences between two versions of the page.

--- knowledge-base:database-migration:setup-and-troubleshooting:mysql:odbc-driver-installation [2020/01/24 11:26]
+++ knowledge-base:database-migration:setup-and-troubleshooting:mysql:odbc-driver-installation [2023/12/15 09:01] (current)
volha.zhyrava
@@ Line 1: / Line 1: @@
+\\
+[[https://www.ispirer.com|Ispirer Website]]
+[[https://www.ispirer.com/products/mysql-migration|Ispirer Capabilities: MySQL Migration]]
+[[https://www.ispirer.com/download/download-demo|Free Trial]]
+====== MySQL: ODBC Driver Installation ======
+**MySQL version 4.1.1 and higher**
+Before you can connect to a MySQL data repository in SQLWays, you must install the MySQL ODBC Driver (Connector/ODBC).
+  * You can download from the [[http://dev.mysql.com/downloads/connector/odbc/|MySQL official website]].
+  * You need to choose install for Windows: “Windows (x86, 32-bit), MSI Installer Connector-ODBC”.
+   * On the "Welcome" page you just need to click "Next" button:
+   *
+{{:knowledge-base:database-migration:setup-and-troubleshooting:mysql:mysql_odbc_inst_1.jpg?nolink|}}
+   * Read and accept the License Agreement
+{{:knowledge-base:database-migration:setup-and-troubleshooting:mysql:mysql_odbc_inst_2.jpg?nolink|}}
+   * Select the Custom setup type
+   *
+{{:knowledge-base:database-migration:setup-and-troubleshooting:mysql:mysql_odbc_inst_3.jpg?nolink|}}
+{{:knowledge-base:database-migration:setup-and-troubleshooting:mysql:mysql_odbc_inst_4.jpg?nolink|}}
+   * Click the "Install" button and wait for the installation process is finished
+{{:knowledge-base:database-migration:setup-and-troubleshooting:mysql:mysql_odbc_inst_5.jpg?nolink|}}
+   * Click the "Finish" button
+{{:knowledge-base:database-migration:setup-and-troubleshooting:mysql:mysql_odbc_inst_6.jpg?nolink|}}
+After you installed the client the "ODBC Data Source Administrator" (Select the Windows Control Panel → Administrative Tools → Data Sources (ODBC) option. The ODBC Data Source Administrator window is displayed.) must be updated with the driver appropriate to the build installed, like in the picture below:
+{{:knowledge-base:database-migration:setup-and-troubleshooting:mysql:mysql_odbc_inst_7.jpg?nolink|}}
+If the appropriate MySQL driver can be seen in the "ODBC Data Source Administrator", the driver installation has completed successfully.
+Then set up the ODBC connection the way it is described in the article: [[knowledge-base/database-migration/setup-and-troubleshooting/mysql/odbc-driver-configuration|ODBC Driver Configuration]]
+\\
+If you have any questions or face with some difficulties, please contact us: [[[email protected]]]