...

View Full Version : Remote connection from iis



Spec_tray
02-19-2009, 07: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

Regards

BubikolRamios
02-19-2009, 10: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 ?

Spec_tray
02-19-2009, 11:05 AM
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



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum