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