Remote connection from iis

[Spec_tray]

hai mates good day..

Do i need to change anything to connect mysql database which i created on my server from my computer(IIS)?

I made remote connection to this database from another server and it works fine using the connection string :

dim Mysql_conn
set Mysql_conn = Server.CreateObject("ADODB.Connection")
Mysql_conn.Open "Driver={mySQL ODBC 3.51 Driver}; Server=myweb.com;Database=my_db; USER=User_name; PASSWORD=paswrd;"

I tried to run same connection string from my computer but it shows an error message like

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Guys any pointer for this prob :)

Thanks in advance

Regards

[BubikolRamios]

1.did you added ip from this new computer(client) to server allowed ips ?


administrator--> USER ADMIN--> ADD NEW HOST ...

2. did you instaled mysql odbc driver on new client ?

[Spec_tray]

2. did you instaled mysql odbc driver on new client ?

Thank you for this pointer BubikolRamios...i just re installed mysql odbc driver problem solved

once again thank you for that

have agood day