Page 1 of 1

ASP + MySQL

Posted: Wed Sep 17, 2003 1:28 am
by theclay7
Hello geeks,

I have a project which is going to use ASP, (pageview per day less than 400 with no more than 3000 users now) but I am not sure about if ASP can talk with MySQL or not, can anyone help me with that?

because If I implement it on MS SQL, it is much more expensive.

Also, in the future, if I am changing the system into .NET, is it also capable of using MySQL instead of MS SQL?

thanks....

Posted: Wed Sep 17, 2003 3:00 am
by JayBird
check out http://www.dwam.net/mysql/

This is a site about ASP working wit MySQL.

Mark

Posted: Wed Sep 17, 2003 3:12 am
by theclay7
thank you very much

Posted: Thu Sep 18, 2003 9:17 pm
by fractalvibes
Yes, you can - the following worked well for me:
Set conn = Server.CreateObject("ADODB.Connection")
conn.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};"_
& "SERVER=localhost;"_
& " DATABASE=mydb;"_
& "UID=gumby;PWD=mypass; OPTION=35"

And thereafter you simply work with it using the standard ADO methods.

Have not tried with .Net, but suspecting you should be able to do equally easily using the various OleDb objects provided therein. Store your connection info in the web.config file.

I still think PHP in many ways has more power and capability than even ASP.NET.......

fv