MySQL Bugs: #64242: mysql-connector-odbc-3.51.30-win32.msi -- Not fully functional, will not connect

Bug #64242	mysql-connector-odbc-3.51.30-win32.msi -- Not fully functional, will not connect
Submitted:	6 Feb 2012 18:01	Modified:	20 Mar 2013 5:53
Reporter:	first last	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / ODBC	Severity:	S1 (Critical)
Version:	3.51.30-win32.msi	OS:	Windows (windows-7 (64-bit))
Assigned to:	Bogdan Degtyariov	CPU Architecture:	Any
Tags:	3.51.30-win32.msi, connection fail, grayed fields

Description:
Last date Installed and attempted use: 2/6/2012 12:31:29 PM (EST)
OS: Windows-7 (64-bit)
Access-2007 (32-bit)
BACK END: mysql-server-5.1.58 using the FreeBSD ports-collection on FreeBSD 
7.3-RELEASE-p2 with all patches applied.
mysql-connector-odbc-3.51.30-win32.msi: Once installed is available via the 'ODBC Data Source Administrator' located @ C:\Windows\SysWOW64\odbcad32.exe.

The attached images show our current experience after installing ODBC-3.51 32-bit. Numerous fields are grayed out, namely "Data Source name" and "Description".  In addition, after entering a "User:", the "Database:" dropdown does not offer a list of available databases the "User:" is authorized to access or otherwise use.  Ultimately, the "Test" button (when pressed) fails.

How to repeat:
Follow the images I've attached or otherwise provided using Access-2007

Suggested fix:
I have no idea

Creating a 'New' Data Source (Access-2007)

Attachment: Create_New_Data_Source-1.png (image/png, text), 153.62 KiB.

Grayed out fields

Attachment: Create_New_Data_Source-2.png (image/png, text), 110.40 KiB.

Connection fails

Attachment: Create_New_Data_Source-3.png (image/png, text), 145.13 KiB.

Additionally we have followed: http://dev.mysql.com/doc/refman/5.1/en/connector-odbc-configuration-dsn-windows.html#conne....  In doing so, we use the 'Test' button and are able to connect, however nothing of what we do via the above link can be seen within Access-2007 on a windows-7 64-bit install.

The workaround is to use the system data source instead of file data source.
Meanwhile I will try to repeat the problem with the file data source.

MySQL ODBC 3.51.30 driver has problems with file DSNs.
I am not able to create a new file DSN. Clicking the test button displays the error message:

Connection Failed: [IM002][Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.

Clicking OK button with all inputs filled causes the error message:

General error: invalid file dsn 'C:\Program Files\Common Files\ODBC\Data Sources\test.dsn'

The contents of the file is as follows:

[ODBC]
DRIVER=MySQL ODBC 3.51 Driver
PORT=0
OPTION=0

Setting Verified status.

ODBC Data Source Administrator -- C:\Windows\SysWOW64\odbcad32.exe

Attachment: Creating_New_Sys_Data_Src_1.png (image/png, text), 153.52 KiB.

ODBC Data Source Administrator -- C:\Windows\SysWOW64\odbcad32.exe

Attachment: Creating_New_Sys_Data_Src_2.png (image/png, text), 182.02 KiB.

ODBC Data Source Administrator -- C:\Windows\SysWOW64\odbcad32.exe

Attachment: Creating_New_Sys_Data_Src_3.png (image/png, text), 191.44 KiB.

ODBC Data Source Administrator -- C:\Windows\SysWOW64\odbcad32.exe

Attachment: Creating_New_Sys_Data_Src_4.png (image/png, text), 151.32 KiB.

ODBC Data Source Administrator -- C:\Windows\SysWOW64\odbcad32.exe

Attachment: Creating_New_Sys_Data_Src_5.png (image/png, text), 146.44 KiB.

ODBC Data Source Administrator -- C:\Windows\SysWOW64\odbcad32.exe

Attachment: Creating_New_Sys_Data_Src_6.png (image/png, text), 193.14 KiB.

ODBC Data Source Administrator -- C:\Windows\SysWOW64\odbcad32.exe

Attachment: Creating_New_Sys_Data_Src_7.png (image/png, text), 240.81 KiB.

ODBC Data Source Administrator -- C:\Windows\SysWOW64\odbcad32.exe

Attachment: Creating_New_Sys_Data_Src_8.png (image/png, text), 164.41 KiB.

I would suggest you to try to list database other than "mysql". i guess you could just not have permissions to see that database.

The problem here is that for file data source the connection string looks as:

Driver={C:\Program Files (x86)\MySQL\Connector ODBC 3.51\myodbc3.dll};SERVER=localhost;UID=root;DATABASE=test;PORT=3306

The driver manager is trying to find the driver named as: {C:\Program Files (x86)\MySQL\Connector ODBC 3.51\myodbc3.dll} instead of loading this file.

The connection string should be as follows:

Driver=MySQL ODBC 3.51 Driver;SERVER=localhost;UID=root;DATABASE=test;PORT=3306

The MySQL ODBC Driver 3.51 is deprecated and it will not receive any new patches or updates. Please use the ODBC Driver 5.2a (ANSI), which is the replacement for the non-UNICODE version 3.51.

The bug is fixed in the newer releases.