ASP Database
September 19, 2007
strconn = "DSN=<name>"
’strconn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.MapPath(DB_PATH & DB_NAME)
strsql = "<query>"
set conn = server.createobject("adodb.connection")
set rs = server.createobject("adodb.recordset")
conn.open strconn
rs.open strsql, conn, 3, 3
Leave a Reply