ASP + MySQL

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
theclay7
Forum Commoner
Posts: 50
Joined: Wed Feb 19, 2003 3:17 am

ASP + MySQL

Post 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....
User avatar
JayBird
Admin
Posts: 4524
Joined: Wed Aug 13, 2003 7:02 am
Location: York, UK
Contact:

Post by JayBird »

check out http://www.dwam.net/mysql/

This is a site about ASP working wit MySQL.

Mark
theclay7
Forum Commoner
Posts: 50
Joined: Wed Feb 19, 2003 3:17 am

Post by theclay7 »

thank you very much
fractalvibes
Forum Contributor
Posts: 335
Joined: Thu Sep 26, 2002 6:14 pm
Location: Waco, Texas

Post 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
Post Reply