Can't connect to MySQL Server

Hi guys,

I have one Macro that pulls information from a MySQL server. This Macro is accessed from different workstations in different regions. When I run it from my computer (Workstation A) it works perfectly. However, we setup new computers in other regions (Workstation B) and here is giving me a String Connection problem.

Workstation B is set up the same way Workstation A was set up. Using same Windows version (64b) and same excel version (32b). Both Workstations have MySQL driver installed and ODBC connector, but still Workstation B is having issues to connect.

This is the String Connection I'm using:
Driver={MySQL ODBC 5.3 ANSI Driver};Server=server.name.com;Port=3306Database=db;User=macro;Password=********;

And this is the moment when it launches the error:

Please Login or Register  to view this content.

This is the same connection String I'm using in Workstation A and it's working.

However, I test my connection using these parameters from the ODBC Data Source Administrator and it works just fine. The connection is perfect.

Do you guys know a reason why this could not be working for some computers under the same configuration and others not?

Any Idea will be highly appreciate it...

Thanks,

Thank you guys. After a lot of communication between my IT manager and I, we agreed that the problem was in the versions used for MySQL, 32B vs 64B. Workstation B has a 64B OS system but a 32B Office Package.

My recommendation is to install both MySQL drivers, 32B & 64B. That solved my problem.

For more valuable info follow this post: http://stackoverflow.com/questions/2...ado-connection