View Full Version : Remote connection from iis

02-19-2009, 08:08 AM
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


02-19-2009, 11:45 AM
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 ?

02-19-2009, 12:05 PM
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