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

  • 常规讨论

  • 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!

    2021年1月21日 9:33

全部回复

  • 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!

    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. 

    2021年1月21日 9:38
  • Hi,

    Welcome to Microsoft office system forum, but please note, the supported language of this forum is Chinese.

    Sub-forums that support English on TechNet have been migrated to Q&A forum.

    To better help you, I suggest you post a new thread on Q&A forum with tag "office-vba-dev" and “sql-server-general”.

    Besides, I would change the type of this thread to be general discussion.

    Thanks for your understanding.

    Regards, 

    Emily


    如果以上回复对您有所帮助,建议您将其标记为答复。如果您对我们的论坛支持有任何的建议,可以通过此邮箱联系我们:tnmff@microsoft.com.

    2021年1月22日 6:14
    版主