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:
    Set oConn = CreateObject("ADODB.Connection")

    On Error GoTo Error_Handler1
    oConn.Open strConn
    On Error GoTo 0

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,