Problem connecting to MySQL from ASP in IIS

Question

I have a ASP application running on a IIS7 server on Windows Vista Home Premium (developing environment). The application has an ASA file to configure connections to the database:

<SCRIPT LANGUAGE=VBScript RUNAT=Server>

Sub Application_OnStart
    Application("db") = 2
    Application("dbconnect") = "Driver={MySQL ODBC 3.51 Driver};Server=localhost;Port=3306;Option=0;Socket=;Stmt=;Uid=root;Pwd=root;CLIENT_MULTI_STATEMENTS=1;Database=appadmin;"
End Sub
</SCRIPT>

Then, requests are handled in asp pages, which first load configuration with the following code:

Session("configid") = 1
dbConnect = Application("dbconnect")
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open (dbConnect)
sql = "select * from settings where configid = "&Session("configid")
Set RS = ExecuteRecordset(sql)
...

Everything seems fine, however, on any request to the site, it logs the following error:

|11|80004005|[Microsoft][ODBC_Driver_Manager]_Data_source_name_not_found_and_no_default_driver_specified 80

Opening a command prompt and running "mysql -uroot -proot -D appadmin" connects to the database without problem.

Any ideas as to what may be causing the problem?

Sorry to bump and old question, but is there a solution for this? I have same problem with IIS 7 and MySQL 5.5 I try drivers MySQL ODBC 5.1 and 3.51 — Gavin
– Gavin, Commented May 9, 2011 at 11:17

Eduardo Molteni · Accepted Answer · 2009-09-04 15:11:20Z

2

My connection string look like this

ConnectionString="Driver={MySQL ODBC 3.51 Driver}; Server=127.0.0.1;Port=3306;
Database=MyDB;User=MyUser;Password=MyPassword;Option=3;"

Looks like yours are missing the user and password and have Option=0 instead of 3

answered Sep 4, 2009 at 15:11

Eduardo Molteni

39.5k25 gold badges145 silver badges212 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Problem connecting to MySQL from ASP in IIS

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related