Forum Discussion

JulieLing's avatar
JulieLing
Copper Contributor
Jan 21, 2021

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

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!

 

developer
excel
Macros and VBA

1 Reply

Sort By
  • JulieLing's avatar
    JulieLing
    Copper Contributor
    Jan 21, 2021
    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.

Resources