Forum Discussion
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 specifie...
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.
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.