Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Driver Manager]Data sou

%3CLINGO-SUB%20id%3D%22lingo-sub-2081625%22%20slang%3D%22en-US%22%3EMicrosoft%20OLE%20DB%20Provider%20for%20ODBC%20Drivers%20error%20'80004005'%20%5BMicrosoft%5D%5BODBC%20Driver%20Manager%5DData%20sou%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2081625%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20experts%2C%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20your%20help%20with%20error%3A%20%22%3C%2FP%3E%3CP%3EMicrosoft%20OLE%20DB%20Provider%20for%20ODBC%20Drivers%20error%20'80004005'%3CBR%20%2F%3E%5BMicrosoft%5D%5BODBC%20Driver%20Manager%5DData%20source%20name%20not%20found%20and%20no%20default%20driver%20specified.%22%3C%2FP%3E%3CP%3EI've%20looked%20at%20numerous%20posts%20but%20none%20helped%20me.%20%3A'(%3C%2FP%3E%3CP%3EMySQL%20database%20server%20is%20running%20on%20Windows10%2064bit.%26nbsp%3B%3C%2FP%3E%3CP%3EClient%20Excel%20where%20the%20VBA%20code%20is%20running%20is%2064%20bit.%3C%2FP%3E%3CP%3E64%20bit%20odbc%20manager%20is%20configured%20with%20System%20DSN%2C%20and%20the%20name%20is%20the%20defined%20in%20connection%20string%20in%20Excel%20ADODB%20connection%20string.%26nbsp%3B%3C%2FP%3E%3CP%3E64bit%20%26amp%3B%2032%20bit%20ODBC%20driver%20has%20been%20installed%20on%20MySQL%20server%20as%20well.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20really%20need%20your%20help%20on%20resolving%20the%20error%20which%20occurs%20when%20ADODB%20Connection.open%20function%20is%20called.%26nbsp%3B%3C%2FP%3E%3CP%3EAppreciated!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2081625%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2081637%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20OLE%20DB%20Provider%20for%20ODBC%20Drivers%20error%20'80004005'%20%5BMicrosoft%5D%5BODBC%20Driver%20Manager%5DData%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2081637%22%20slang%3D%22en-US%22%3ESome%20additional%20info%3A%3CBR%20%2F%3EI've%20granted%20user%20permission%20on%20both%20server%20level%20as%20well%20as%20MySQL%20lever%3CBR%20%2F%3E%3CBR%20%2F%3EVBA%20connection%20string%20looks%20like%3A%3CBR%20%2F%3E%3CBR%20%2F%3EDriver%3D%7BMySQL%20ODBC%205.3%20Unicode%20Driver%7D%3BServer%3D%22%20%26amp%3B%20serverAddress%20%26amp%3B%20%22%3BDatabase%3Djkydb1%3BUid%3Dagent%3Bpwd%3Dpassword%3BConnect%20Timeout%3D500%3BOPTION%3D16427%22%3CBR%20%2F%3E%3CBR%20%2F%3EIncoming%20rules%20of%20MySQL%20server%20firewall%20is%20also%20added.%3C%2FLINGO-BODY%3E
New Contributor

Hello 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. 

Appreciated!

 

1 Reply
Some additional info:
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.