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....
ASP + MySQL
Moderator: General Moderators
-
fractalvibes
- Forum Contributor
- Posts: 335
- Joined: Thu Sep 26, 2002 6:14 pm
- Location: Waco, Texas
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
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