Bug #92295 Specified driver could not be loaded due to system error 182: (MySQL ODBC 8.0
Submitted: 5 Sep 2018 14:13 Modified: 29 Nov 2018 4:44
Reporter: Kadirvel k Email Updates:
Status: No Feedback Impact on me:
None 
Category:Connector / ODBC Severity:S2 (Serious)
Version:8.0.12 OS:Windows (Windows 2012 R2 server)
Assigned to: CPU Architecture:Any

[5 Sep 2018 14:13] Kadirvel k
Description:

HP UFT tool version: 14.0
Database : MySQL 8.0
Connector version :8.0.12(32bit)

Note : HP UFT Tool will support only 32bit connector

when I tried to execute my automation script through the HP UFT Tool to connect the MySQL 8.0 database to retrieve the record, I am getting the following error

Specified driver could not be loaded due to system error  182:  (MySQL ODBC 8.0 ANSI Driver, C:\Program Files (x86)\MySQL\Connector ODBC 8.0\myodbc8a.dll)

Even I tried to execute through 64bit connector, I am getting the same error.

How to repeat:
Execute the following code in HP UFT tool.

set cn = CreateObject("ADODB.Connection")
Set objRecordSet = createobject("ADODB.RecordSet")
		
		cn.Open "DRIVER={MySQL ODBC 8.0 ANSI Driver};SERVER=localhost;DATABASE=integration;UID=root;PASSWORD=root;Port=3306;OPTION=3"

Once it execute the cn.open line, it throwing error.
[5 Sep 2018 14:25] Kadirvel k
Attaching screen shot for the error.
[29 Oct 2018 4:44] Bogdan Degtyariov
Hi Kadirvel,

Your problem might occur because Visual C++ 2015 redistributable package is not installed in the system. If it is not installed the package can be downloaded from this page:

https://www.microsoft.com/en-au/download/details.aspx?id=48145

Sometimes users install only the VC++ 2017 redistributable and expect things to work correctly. Unfortunately, the VC++ 2017 redistributable is not a superset of the VC++ 2015 redistributable. Therefore, the version 2015 must be specifically installed.
[30 Nov 2018 1:00] Bugs System
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".
[15 Jan 2019 22:58] Greg Mayer
I have same issue.
[28 Jan 2019 6:00] 安乐 汪
I also have this problem . then  i install https://dev.mysql.com/downloads/file/?id=484299  Windows (x86, 64-bit), MSI Installer	5.3.12  https://dev.mysql.com/downloads/file/?id=484298 
Windows (x86, 32-bit), MSI Installer	5.3.12
 then it can be use
[15 Feb 2019 20:03] Narasimha Suryadevara
I have the same issue connecting to MYSQL with HP UFT 12.02 . did any one had a solution?