DaniWeb Forum Index > Web Development > ASP

can i use mysql database with asp

Please support our ASP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Sep 2005

Posts: 139

Reputation: aarya is an unknown quantity at this point

Solved Threads: 0

aarya

Offline

Junior Poster

can i use mysql database with asp

Sep 19th, 2005

i want to learn asp . can i use mysql database with asp.how to connect to mysql database.
will u tell me the basic asp tutorials for beginners.

•

Join Date: Jan 2005

Posts: 294

Reputation: zippee is an unknown quantity at this point

Solved Threads: 6

zippee

Offline

Posting Whiz in Training

Re: can i use mysql database with asp

Sep 21st, 2005

You can. But it would be much easy to use PHP with MySQL, at least there is phpMyAdmin to help with the interface with database. Connecting mySQL in ASP is as follow (change the dbname,username and password to yours):

 Help with Code Tags 
 ASP Syntax (Toggle Plain Text) 
<%
' Open database
Dim Conn, RS
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "Driver={MySql ODBC 3.51 Driver}; Server=localhost; database=dbname; uid=username; pwd=password; option=3;"
Set RS = Conn.Execute("SELECT * From tblcart")
' display results
While Not RS.EOF
Response.Write RS.Fields("fieldname") & "<br>"
RS.MoveNext
Wend
' closing connection
RS.Close
Conn.Close
Set RS = Nothing
Set Conn = Nothing
<%
' Open database
Dim Conn, RS
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "Driver={MySql ODBC 3.51 Driver}; Server=localhost; database=dbname; uid=username; pwd=password; option=3;"
Set RS = Conn.Execute("SELECT * From tblcart")
' display results
While Not RS.EOF
Response.Write RS.Fields("fieldname") & "<br>"
RS.MoveNext
Wend
' closing connection
RS.Close
Conn.Close
Set RS = Nothing
Set Conn = Nothing

Since you just want to start learning ASP, it would be better to learn php, if you want to use mySQL. You can easily change to ASP or other server side language in the future as they are very much the same. I learnt ASP at the first place and store data in MS Access and now move to php and mySQL. It just take me couple months to master php.

Ecommerce-Web-Store.com Building Your e-Business.

•

Join Date: Sep 2005

Posts: 139

Reputation: aarya is an unknown quantity at this point

Solved Threads: 0

aarya

Offline

Junior Poster

Re: can i use mysql database with asp

Sep 23rd, 2005

thank u very much, yes i m learning php. thnaks for ur sajaction

•

Join Date: May 2006

Posts: 4

Reputation: HemantK is an unknown quantity at this point

Solved Threads: 0

HemantK

Offline

Newbie Poster

Re: can i use mysql database with asp

May 25th, 2006

Hi,

you can learn more about asp.

just browse to www.asptutorial.info

Bye

HemantK

•

Join Date: May 2006

Posts: 1

Reputation: bijaykumar is an unknown quantity at this point

Solved Threads: 0

bijaykumar bijaykumar is offline

Offline

Newbie Poster

Re: can i use mysql database with asp

May 28th, 2006

how do i run mysql server 2000 in my pc

•

Join Date: Mar 2005

Posts: 131

Reputation: william_stam is an unknown quantity at this point

Solved Threads: 2

william_stam william_stam is offline

Offline

Junior Poster

Re: can i use mysql database with asp

Jun 7th, 2006

there isnt a mysql version 2000. and that you would have to ask in the "database" forums

•

Join Date: Jun 2006

Posts: 4

Reputation: oscarsierra is an unknown quantity at this point

Solved Threads: 0

oscarsierra oscarsierra is offline

Offline

Newbie Poster

Re: can i use mysql database with asp

Jun 17th, 2006

I think there is one problem with mySQL when using ASP, when mySQL change version, your syntax written in ASP can be "out of date".... I suggest you to use ASP with MSSQL and mySQL with PHP, that makes it much easier to get help in the different forums and knowledge bases too! My experiences only, not necessary the truth :-)

Last edited by oscarsierra; Jun 17th, 2006 at 8:50 am.