sloppycode.net
ASP Database access: mySQL
Using mySQL with ASP.
Home
›
Code snippets
›
ASP
›
ASP Database access: mySQL
A very basic example (kept here for reference) of using mySQL with ASP. You will need the mySQL ODBC drivers for this to work, available at
this website
<% ' Over-ride 90 second default to 1 hour Server.ScriptTimeout = 21600 Dim Conn,RS,SQL,DSN DSN = "DBQ=datbase;Driver={MySQL};ServerName=168.192.0.1;uid=username;pwd=password;OPTION=16386" Set RS = Server.CreateObject("ADODB.Recordset") Set Conn = Server.CreateObject("ADODB.Connection") ' Start time Response.Write "Started: " & Hour(Now()) & ":" & Minute(Now()) & ":" & Second(Now()) & "<br>" Conn.Open DSN SQL = "SELECT * FROM table" RS.Open SQL,Conn,1,2 Do While Not RS.EOF i = i +1 RS.MoveNext Loop ' End Time Response.Write "Finished: " & Hour(Now()) & ":" & Minute(Now()) & ":" & Second(Now()) & "<br>" Response.Write i & " records found." %>
{Name}
Says:
{Date}
{Text}
› Home
› C#
› Snippets
› Articles
› Tools
› Taglines
› ASP
› Dictionary Object
› FSO
› Unix cheat sheet
› Gaming
› CSS
› Yak
› Umbraco
› About
› Contact
› Privacy
› Projects
› Search
› Sitemap
Buy on Amazon
Buy on Amazon
Buy on Amazon
Buy on Amazon
