ASP Database access: SQL Server
Using SQL Server with ASP.

• Home
• ›
• Code snippets
• ›
• ASP
• ›
• ASP Database access: SQL Server

A very basic example (kept here for reference) of using SQL Server 2000 with ASP.
<% ' Over-ride 90 second default to 1 hour Server.ScriptTimeout = 21600 Dim Conn,RS,SQL,DSN DSN = "Driver={SQL Server};Server=server;Database=database;UID=username;PWD=password;" 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