For X reason I must make a connection from ASP (classic) hosted on server 1 (windows) to MySQL hosted on a server 2 (linux), I have installed the driver and makes the connection, but I get the following error:
[MySQL] [ODBC 5.3 (a) Driver] Access denied for user 'user' @ 'ipservidor1' (using password: YES)
The problem is that the connection string has the IP of server 1 and not server 2 and when I add the IP of server 2 I get the following error:
[MySQL] [ODBC 5.3 (a) Driver] Access denied for user 'user @ ipservidor2' @ 'ipservidor1' (using password: YES)
Do you know what may be happening? Thanks.