MySQL Bugs: #98481: error during install error 1918 and 126 module could not be found myodbc8S.dll

Bug #98481	error during install error 1918 and 126 module could not be found myodbc8S.dll
Submitted:	4 Feb 2020 11:45	Modified:	9 May 2020 7:32
Reporter:	Holger Blum	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	Connector / ODBC	Severity:	S3 (Non-critical)
Version:	8.0.19	OS:	Windows (Server 2016 64bit)
Assigned to:	MySQL Verification Team	CPU Architecture:	x86

Description:
Error during install.

version 8.0.19 64bit msi packet

Error 1918.
Error installing ODBC driver MySQL ODBC 8.0 ANSI Driver, 
ODBC error 13: The setup routines for the MySQL ODBC 8.0 ANSI Driver ODBC driver could not be loaded due to system 
error code 126: 
The specified module could not be found. (C:\Program Files\MySQL\Connector ODBC 8.0\myodbc8S.dll).. 
Verify that the file MySQL ODBC 8.0 ANSI Driver exists and that you can access it.

How to repeat:
run msi

I see something like this with the MSI installer - but the error is truncated.

Downloading zip (non-MSI installer) and running exe pops up a need for VCRUNTIME140_1.dll

I was able to install the latest VC runtime (in my case, Microsoft Visual C++ 2015-2019 Redistributable (x64) - 14.24.28127) which allows the install to complete without error.

I got the latest runtime from here:
https://support.microsoft.com/en-us/help/2977003/the-latest-supported-visual-c-downloads

It appears that VC 2019 now enables a compiler setting by default that requires an updated runtime to resolve the dependency on vcruntime140_1.dll

More information on the issue:
https://developercommunity.visualstudio.com/content/problem/852548/vcruntime140-1dll-is-mi...

This problem happens on windows7(64bit) too, when run this version msi.

Same error on windows 10 x64.

Hello Holger Blum,

Thank you for the bug report.
Please install VC++2019 redistributable, which will fix the problem. Thanks

Regards,
Ashwini Patil

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

I tried installing the ODBC Driver for MySQL on June 23, 2020 and got the same error. I tried twice, same result.

Thanks to Ashwini Patil

When I Install VC++2019 redistributable, it fixed the problem. 

Thanks a lot