Bug #80945 Problem installing x86 version of ODBC driver
Submitted: 4 Apr 2016 7:38 Modified: 5 Apr 2016 9:19
Reporter: Andrea Carolfi Email Updates:
Status: Not a Bug Impact on me:
None 
Category:Connector / ODBC Severity:S4 (Feature request)
Version:5.3.6 OS:Windows (7SP1)
Assigned to: CPU Architecture:Any
Tags: installation

[4 Apr 2016 7:38] Andrea Carolfi
Description:
I've a machine running Windows Seven Service Pack 1 64bit. I've MySQL Server 5.6.26 64 bit with Connector/ODBC 5.3.4 both 32 and 64bit installed.

Yesterday I've tried to update my system to the latest versions available so 5.6.29 for the server and 5.3.6 for the connectors.

After the installer finished its operations I've noticed that the server and the 64 bit version of the connector was updated but not the x86 version (that was completely removed from the system). 

I've tried to manually install the 32bit of the ODBC connector using its standalone installer but while it's installing the ODBC driver an error pops up informing that the operation cannot be done due to a driver missing (the error message is truncated).

I've tried to remove the 64bit version and then reinstall the 32bit version with no success. I've to restore 5.3.4 release of both versions to reactivate the functionality.

How to repeat:
1. Download the mysql-connector-odbc-5.3.6-win32 installer.
2. Try to install it.

Suggested fix:
Probably the 32bit installer is missing some dlls.
[4 Apr 2016 9:27] Chiranjeevi Battula
Hello Andrea Carolfi,

Thank you for the bug report.
I could not repeat the issue at our end using with Windows 7 and Connector / ODBC 5.3.6 32 bit version. 

This is most likely duplicate of Bug #70661, please see Bug #70661.

Please go through the below forums
http://forums.mysql.com/read.php?37,599399,599399#msg-599399

Thanks,
Chiranjeevi.
[4 Apr 2016 9:27] Chiranjeevi Battula
Screenshot.

Attachment: 80945.JPG (image/jpeg, text), 31.46 KiB.

[4 Apr 2016 12:55] Peter Laursen
The "MySQL Installer" will only accept ONe 832 bit or 64 bit) 'major' version of any program (server, tools connector or w-atever).  There are other reports here about this.

However connectors may be downloaded from here http://dev.mysql.com/downloads/connector/ as well and I beleive they wll bot install.

-- Peter
-- not a MySQl/Oracle person
[4 Apr 2016 13:59] Andrea Carolfi
Hello to everyone.

Thank you for your replies. I've followed the links posted, I understood thid problem seems related to some Visual C++ Redistributable package, am I right?

Well if it's the case I don't understand why the 64bit version install itself flawlessly and also both 32/64bit of previous version.

My system is currently updated, I've Microsoft Visual Studio 2010 Professional SP1 currently installed and patched and I've ran Windows Update just on sunday.

Unfortunately I cannot attach any images to the report. I'll try to provide the exact version of the required packages if you need them.

Microsoft Visual C++ 2010 x64 Redistributable - 10.0.40219
Microsoft Visual C++ 2010 x64 Runtime - 10.0.40219
Microsoft Visual C++ 2010 x86 Redistributable - 10.0.40219
Microsoft Visual C++ 2010 x86 Runtime - 10.0.40219
Microsoft Visual C++ 2013 Redistributable (x64) - 12.0.30501

Regards.
[4 Apr 2016 14:27] Andrea Carolfi
Installer error

Attachment: MySQL ODBC Installer Error.png (image/png, text), 9.30 KiB.

[4 Apr 2016 14:32] Andrea Carolfi
Redist packages

Attachment: MSVC Redist packages.png (image/png, text), 138.32 KiB.

[4 Apr 2016 21:58] Michał Moreń
Try to install Microsoft Visual C++ 2013 Redistributable (x86) and then 5.3.6 Connector 32bit7528
[4 Apr 2016 21:59] Michał Moreń
Try to install Microsoft Visual C++ 2013 Redistributable (x86) and then 5.3.6 Connector 32bit
[5 Apr 2016 8:08] Andrea Carolfi
Hello everybody,

Thank you Michał Moreń, your reply answered my issue, After I've installed the 32bit version of MSVC 2013 Runtime the 32bit version of the ODBC installed correctly.

However IMHO it's a pity the installer doesn't check the presence of the needed requirements and that also the standalone installer doesn't provide a more clear error message.

Summarizing: the last version of ODBC driver running on MSVC 2010 Runtime is 5.3.4, isn't it?

Thank you very much.
[5 Apr 2016 9:19] Chiranjeevi Battula
Hello Andrea Carolfi,

Thank you for your feedback.

Thanks,
Chiranjeevi.
[15 Apr 2016 12:24] Chiranjeevi Battula
http://bugs.mysql.com/bug.php?id=81096 marked as duplicate of this one.
[22 Jul 2016 6:42] Chiranjeevi Battula
http://bugs.mysql.com/bug.php?id=82315 marked as duplicate of this one.
[22 Sep 2016 7:07] Chiranjeevi Battula
http://bugs.mysql.com/bug.php?id=83083 marked as duplicate of this one.