MySQL Bugs: #40451: ODBC connector does not appear

Bug #40451	ODBC connector does not appear
Submitted:	31 Oct 2008 9:30	Modified:	8 Nov 2008 10:20
Reporter:	Andy Statham	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	Connector / ODBC	Severity:	S1 (Critical)
Version:	3.51, 5.1	OS:	Windows (Vista (32))
Assigned to:		CPU Architecture:	Any
Tags:	connector, driver, ODBC, windows

Description:
Trying to install MySQL ODBC connector on Windows computer running Vista.  Everything runs as usual but the driver does not appear in the list when I go to the Data Source manager.

I have installed it on XP and Vista machines but not on this one.  

How to repeat:
Run the installer.  Seems to be specific to the computer.  Can't see what is different about this one.

Suggested fix:
No idea

Hi Andy and thanks for your report.

If something's critical, please take time to search bugsdb for solution and provide as much info as you can. With info provided so far, I can only guess...
  o c/ODBC 5.0 is discontinued, please use 5.1 instead
  o If you're on Vista x64 and you're using older MyODBC driver (don't see versions...) is is possible that you do not see driver in CP. Reason is that we used to have only 32bit versions of MyODBC (as all of the clients were 32bit and there is actually no use of 64bit driver but to stop reports like this). In this case you need to start 32bit ODBC driver manager instead of 64bit one you see in CP...

Correction, I have tried ODBC connector 3.51 and 5.1.  Neither show up when insalled using windows installer files mysql-connector-odbc-5.1.5-win32.msi or mysql-connector-odbc-3.51.26-win32.zip.

Andy,

Do you have the FileMaker ODBC driver installed?

MyODBC driver on Vista Ultimate 64-bit

Attachment: myodbc-on-vista.png (image/png, text), 66.54 KiB.

I couldn't repeat on Vista Ultimate 64-bit. See attached figure.

Miguel, it's not 64bit issue. Andy said Vista(32). Probably Jess is on right track. So Andy, any 3rd party ODBC drivers already installed?

No third party drivers installed.  As far as I am aware it's a new computer straight out of the box.

Searches reveal that this is not a new problem.  I saw one going back to 2004 relating to XP with SP2.  I've tried the suggested fixes without success:

http://forums.mysql.com/read.php?37,31449,172121#msg-172121
http://forums.mysql.com/read.php?37,31449,32571#msg-32571
http://osdir.com/ml/db.mysql.odbc/2007-06/msg00019.html

The first two are caused by "corruption" when installing a third party driver. The third one is inconclusive, but likely the same issue or only installing a 32-bit driver on 64-bit Windows. Can you export the following registry branch and upload it to this bug report?

HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers

I will try to get that info on Monday.  Thanks to everyone for taking the time to help.

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers]
"SQL Server"="Installed"
"Microsoft ODBC for Oracle"="Installed"
"Microsoft Access Driver (*.mdb)"="Installed"
"Microsoft Access-Treiber (*.mdb)"="Installed"
"Driver do Microsoft Access (*.mdb)"="Installed"
"Microsoft dBase Driver (*.dbf)"="Installed"
"Microsoft dBase-Treiber (*.dbf)"="Installed"
"Driver do Microsoft dBase (*.dbf)"="Installed"
"Microsoft Excel Driver (*.xls)"="Installed"
"Microsoft Excel-Treiber (*.xls)"="Installed"
"Driver do Microsoft Excel(*.xls)"="Installed"
"Microsoft Paradox Driver (*.db )"="Installed"
"Microsoft Paradox-Treiber (*.db )"="Installed"
"Driver do Microsoft Paradox (*.db )"="Installed"
"Microsoft Text Driver (*.txt; *.csv)"="Installed"
"Microsoft Text-Treiber (*.txt; *.csv)"="Installed"
"Driver da Microsoft para arquivos texto (*.txt; *.csv)"="Installed"
"Microsoft Visual FoxPro Driver"="Installed"
"Microsoft FoxPro VFP Driver (*.dbf)"="Installed"
"Microsoft dBase VFP Driver (*.dbf)"="Installed"
"Microsoft Visual FoxPro-Treiber"="Installed"
"Driver para o Microsoft Visual FoxPro"="Installed"
@=""
"FileMaker Oracle8 Driver"="Installed"
"FileMaker Text Driver (*.*)"="Installed"
"Microsoft Access Driver (*.mdb, *.accdb)"="Installed"
"Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)"="Installed"
"Microsoft Access dBASE Driver (*.dbf, *.ndx, *.mdx)"="Installed"
"Microsoft Access Paradox Driver (*.db)"="Installed"
"Microsoft Access Text Driver (*.txt, *.csv)"="Installed"
"MySQL ODBC 5.1 Driver"="Installed"

I can confirm that the connectors are installing and showing up in the registry.  I've tried both 3.51 and 5.1.  However, neither of them show up when I go to create a new source in the ODBC Data Source Administrator.

If I go to the File DSN tab it shows:
MySQL (from program files) and inside this
Connector ODBC 5.1
MySQL Connector Net 5.0.9
MySQL Server 6.0

Does this help?  Can I make connection without using the ODBC Data Source Administrator?

This is the FileMaker issue, follow the instructions here:

http://forums.mysql.com/read.php?37,31449,32571#msg-32571

You were correct, it's the "@" problem.  Many thanks for solving that for me.