Error 800a01a8 -- Any help?

Results 1 to 2 of 2

Thread: Error 800a01a8 -- Any help?

  1. #1
    Join Date
    Dec 1969
    Posts
    199

    Default Error 800a01a8 -- Any help?

    Hi All,<BR><BR>I&#039m getting the error message: Microsoft VBScript runtime error &#039 800a01a8&#039 Object required: &#039DRIVER={Microsoft Ac&#039 when trying to run the following code:<BR><BR>Dim objDC, objRecordset, SQL,holdvalue<BR><BR><BR>objDC = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("/../../../databases/Development/labs_dev/users.mdb") & ";"<BR><BR>Set objRecordset = Server.CreateObject("ADODB.Recordset")<BR>objRecor dset.Open "calendar_one", objDC<BR><BR><BR>If Request.Form("btnStart") = "Start Session" Then<BR> <BR> set holdvalue = Request.Form("login")<BR> SQL = "Select HRID from calendar_one where HRID =" & holdvalue & "&#039;"<BR> Response.Write SQL<BR> &#039objRecordset.Open "calendar_one", SQL, objDC<BR> objRecordset = objDC.Execute(SQL)<BR> <BR><BR>Any help would be appreciated.<BR>

  2. #2
    Join Date
    Dec 1969
    Posts
    2,849

    Default RE: Error 800a01a8 -- Any help?

    Try placing this code before objDC<BR>Dim objConn<BR>Set objConn = Server.CreateObject("ADODB.Connection")<BR><BR>The n, after you assign objDC to the connection string, try:<BR>objConn.Open objDC<BR><BR>Finally, on objREcordset.Open, change it to:<BR>objRecordset.Open "calendar_one", objConn<BR><BR>Let me know if that works!<BR><BR>:)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •