MySQL Forums
Forum List  »  Connector/ODBC

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
Posted by: Julie Ling
Date: January 24, 2021 11:21PM

Dear experts,

I need your help with error: "

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager]Data source name not found and no default driver specified."

I've looked at numerous posts but none helped me. :'(

MySQL database server is running on Windows10 64bit.

Client Excel where the VBA code is running is 64 bit.

64 bit odbc manager is configured with System DSN, and the name is the defined in connection string in Excel ADODB connection string.

64bit & 32 bit ODBC driver has been installed on MySQL server as well.

I really need your help on resolving the error which occurs when ADODB Connection.open function is called.

Just FYI,
I've granted user permission on both server level as well as MySQL lever

VBA connection string looks like:

Driver={MySQL ODBC 5.3 Unicode Driver};Server=" & serverAddress & ";Database=jkydb1;Uid=agent;pwd=password;Connect Timeout=500;OPTION=16427"

Incoming rules of MySQL server firewall is also added.

Appreciated!

Options: ReplyQuote


Subject
Written By
Posted
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
January 24, 2021 11:21PM


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.