ODBC Connector broke with Win2019 update
I have several legacy vbscript/ASP apps that were connecting to MySQL 8 via ODBC driver 8.0. In the past week, something changed that is preventing all of those apps from being able to connect to MySql.
I've tried upgrading drivers to 8.4, double checked the connection strings, verified successful test from the 64 bit ODBC administration, and can access the databases from php and the workbench. Even tried dropping back to 5.3 with the same results.
I don't see any MySql drivers in the 32 bit ODBC administrator, even when staring it from the SysWOW64 folder.
I'm at a loss and need to get these apps running again. The error message is:
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Connection String:
{DRIVER=MySQL ODBC 8.4 Unicode Driver};
UID=*******;USER=*********;PASSWORD=*************;
SERVER=localhost;PORT=3306;_
NO_SCHEMA=1;DB=*******;DATABASE=*******;
Subject
Written By
Posted
ODBC Connector broke with Win2019 update
June 17, 2024 09:33AM
Sorry, only registered users may post in this forum.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.