can i used MySQL as database server for asp?

[bungek84]

hai everyone..i'm still beginner in this ASP..
jus wanna know is it ok if i used MySQL as database? can anyone teach..
really needs ur helps and guides..thanx alot guys..

:)

[SheSaidImaPregy]

yes, you can use it. You need to connect to it. Visit www.connectionstrings.com for examples.

[TobbeK]

Ooooh yes you can

Here's a working connectionstring:

Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DRIVER={MySQL ODBC 5.1 Driver}; SERVER=localhost; DATABASE=<yourdatabasename>; UID=<yourusername>; PWD=<yourpassword>;"

Change SERVER=localhost if your database is placed somewhere else.
You can download all of the drivers from mysql.com. You may have to setup an DSN connector for the drivers.

[dilipv]

hi bungek84,
You can use MySql with ASP.net easily. There are lots of article's you can learn from there.
But for your help please visit the given link.

http://www.codeproject.com/KB/webforms/MySQLsuite.aspx

http://www.15seconds.com/issue/050210.htm

Hope this will help you.
Thanks & Regards
Dilipv