Member Avatar for jen140

Hello all.
I want to add the mysql to ODBC sources.
Im currently running windows vista, and in the control panel, Data Sources (ODBC) when i try to add a system Dns as source i cant find mysql in the list.
Here is a pic(so you dont spam or understand the ideia easier):

Thanks in advance.

  • 2 Contributors
  • 2 Replies
  • 114 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by jen140

Dani AI

Generated

A compact troubleshooting checklist and notes for the "MySQL not listed in ODBC Data Sources" problem (builds on 's driver question and 's report).

  • Confirm the driver is installed: open the ODBC Data Source Administrator and check the Drivers tab. If no MySQL driver appears, the Connector/ODBC installer is missing or failed.
  • Match bitness (very common pitfall): 32-bit apps require 32-bit ODBC drivers; 64-bit apps require 64-bit drivers. On 64-bit Windows there are two ODBC GUIs — use C:\Windows\SysWOW64\odbcad32.exe to manage 32-bit drivers and C:\Windows\System32\odbcad32.exe for 64-bit drivers.
  • Choose the right DSN type: use a System DSN for services and system-wide use, User DSN for a single user account.
  • Install or re-install the correct Connector/ODBC package (run the MSI as Administrator). Official downloads are available from MySQL: MySQL Connector/ODBC downloads.
  • Registry checks (advanced): installed drivers list under HKLM\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers and, for 32-bit drivers on 64-bit Windows, HKLM\SOFTWARE\WOW6432Node\ODBC\ODBCINST.INI\ODBC Drivers.
  • If a DSN is created but fails to connect: test connectivity to the MySQL server (port 3306), confirm server bind-address and user privileges, and check firewalls.

Cautions: avoid mixing driver and app bitness; uninstall older connector versions before installing a different bitness; run installers with administrator rights.

Recommended Answers

All 2 Replies

Member Avatar for Member #46692

Have you installed the mySQL ODBC datasource driver?

Member Avatar for jen140

Thought it comes with full install of mysql.
Installed x64 version of it and it works, thanks very much =).

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.