Microsoft OLE DB Provider for ODBC Drivers error '80004005'

Question

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!

Discussion
You cannot vote on your own post
0
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.

Answer 1

First of all, this is an error from the driver manager, so you are not even coming to the ODBC driver, even less your MySQL Server.

I did a quick test on my machine where I deliberately misspelled the name of the ODBC Driver, and I got the same error message as you.

This leads me to think that you have the name of the ODBC driver wrong, or you have not installed the driver. Unfortunately, I cannot help you with the driver name. I saw this, because you have tagged this for SQL Server, which is a different product from MySQL, and my expertise is with SQL Server, not MySQL.

Answer 2

ODBC driver is installed on the MySQL driver, both 32 bit and 64 bit.

You have the ODBC driver on the machine where you have MySQL. But do you have the ODBC driver on the machine where you have Excel?

Answer 3

Hi @Ms Ling ,

We add the SQL server general tag when we meet the issues about MS SQL server. You issue is related to MySQL , I suggest you ask the experts in the MySQL forum to get better help.

MySQL Forums
Or
https://stackoverflow.com/questions/tagged/mysql

Best regards,
Cathy Ji

---

If the response is helpful, please click "Accept Answer" and upvote it, thank you.