MySQL Bugs: #83083: Mysql with Excel VBA issue, 64bit windows and 32bit office

Bug #83083	Mysql with Excel VBA issue, 64bit windows and 32bit office
Submitted:	21 Sep 2016 15:51	Modified:	22 Sep 2016 9:18
Reporter:	Mike C	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	Connector / ODBC	Severity:	S2 (Serious)
Version:	ODBC 5.3	OS:	Windows (windows 10 64bit)
Assigned to:		CPU Architecture:	Any

Description:
Trying to use VBA to connect to MySql database.

With the ODBC driver 64bit, this is not possible with 32bit office. And was advised to install the ODBC 32bit 5.3.

For the life of me it will not install with error 1918: & error code 126: cannot be found.

Googling advised uninstalling redistributables and installing various others, none of which has solved the issue.

I have tried microsoft cisual c++ redstributable 64 & 32bits, with them both and indivdually installed. No luck.

Any help will be greatly appreciated.

How to repeat:
Try and install the ODBC connector 5.3

Hello Mike,

Thank you for the bug report.
This is most likely duplicate of Bug #80945, please see Bug #80945.
Try to install Microsoft Visual C++ 2013 Redistributable (x86) and then 5.3.6 Connector 64/32bit.

Thanks,
Chiranjeevi.

Well it seems I have managed to solve the problem. All be it accidentally.

I removed all instances of mysql from the MySQL installer. So according to that there was nothing installed. I then rebooted.
Then I installed the sql server x86 architecture first, then the x84 architecture for everything else, and the 32bit ODBC installed with a hitch this time.

Tried in excel vba, and had to edit the driver part for it only to say "Driver 5.3" (When in actual fact the ODBC driver is version 5.3.6)

Resulting in VBA connecting wonderfully to MySQL database.

Thanks for your help. All is good now.

Bottom line for vba use, only install 32bit MySQL (And all of instances) for it to work. Not just the driver.

Rgds

*without a hitch