943,796 Members | Top Members by Rank

Ad:
  • ASP Discussion Thread
  • Unsolved
  • Views: 9286
  • ASP RSS
Sep 19th, 2005
0

can i use mysql database with asp

Expand Post »
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.
Similar Threads
Reputation Points: 11
Solved Threads: 0
Junior Poster
aarya is offline Offline
139 posts
since Sep 2005
Sep 21st, 2005
0

Re: can i use mysql database with asp

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):
ASP Syntax (Toggle Plain Text)
  1. <%
  2. ' Open database
  3. Dim Conn, RS
  4. Set Conn = Server.CreateObject("ADODB.Connection")
  5. Conn.Open "Driver={MySql ODBC 3.51 Driver}; Server=localhost; database=dbname; uid=username; pwd=password; option=3;"
  6. Set RS = Conn.Execute("SELECT * From tblcart")
  7. ' display results
  8. While Not RS.EOF
  9. Response.Write RS.Fields("fieldname") & "<br>"
  10. RS.MoveNext
  11. Wend
  12. ' closing connection
  13. RS.Close
  14. Conn.Close
  15. Set RS = Nothing
  16. 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.
Reputation Points: 10
Solved Threads: 7
Posting Whiz in Training
zippee is offline Offline
294 posts
since Jan 2005
Sep 23rd, 2005
0

Re: can i use mysql database with asp

thank u very much, yes i m learning php. thnaks for ur sajaction
Reputation Points: 11
Solved Threads: 0
Junior Poster
aarya is offline Offline
139 posts
since Sep 2005
May 25th, 2006
0

Re: can i use mysql database with asp

Hi,


you can learn more about asp.

just browse to www.asptutorial.info

Bye


HemantK
Reputation Points: 10
Solved Threads: 0
Newbie Poster
HemantK is offline Offline
4 posts
since May 2006
May 28th, 2006
0

Re: can i use mysql database with asp

how do i run mysql server 2000 in my pc
Reputation Points: 10
Solved Threads: 0
Newbie Poster
bijaykumar is offline Offline
1 posts
since May 2006
Jun 7th, 2006
0

Re: can i use mysql database with asp

there isnt a mysql version 2000. and that you would have to ask in the "database" forums
Reputation Points: 10
Solved Threads: 2
Junior Poster
william_stam is offline Offline
131 posts
since Mar 2005
Jun 17th, 2006
0

Re: can i use mysql database with asp

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.
Reputation Points: 10
Solved Threads: 0
Newbie Poster
oscarsierra is offline Offline
4 posts
since Jun 2006

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in ASP Forum Timeline: Count number of checkboxes being checked in asp.net
Next Thread in ASP Forum Timeline: Small date problem





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC