Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003
    Location
    Plymouth Meeting, Pa
    Posts
    3

    Unanswered: 0x800A01A8 Object Required Message

    I'm trying to create some code to write a simp[le set of survey responses to an Access data base. I keep getting the error

    Microsoft VBScript runtime (0x800A01A8)
    Object required: ''
    /test1/survey_reply.asp, line 10

    when I go to run my code. I'm taking the fields from a previous module, but I can't get past my . Here are the ffirst set of lines in my code:


    <html>
    <head><title>Desktop Technical Services Survey Reply</title><head>
    <body bgcolor="#CCCCFF">
    <%

    Actionvar=Request.QueryString("actionvar")

    dim conn

    conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=c://Inetpub//wwwroot//test1//survey.mdb"

    SQLstmt = "INSERT INTO Survey (Name,overall_installation,overall_interview,deliv ery,hardware,software,data_move,configs,shares_pri nters, training,problems,followup,improvement,comments)"
    SQLstmt = SQLstmt & " VALUES ('" & request.form("Name") & "','" & request.form("overall_installation") & "','" & request.form("overall_interview") & "','" & request.form("delivery") & "','" & request.form("hardware") & "','" & request.form("software") & "','" & request.form("data_move") & "','" & request.form("configs") & "','" & request.form("shares_printers") & "','" & request.form("training") & "','" & request.form("problems") & "','" & request.form("followup") & "','" & request.form("improvement") & "','" & request.form("comments") & "')"
    %>
    <HR>
    SQL statement: <%=SQLstmt%>
    <HR>
    <%
    conn.execute(SQLstmt)

    conn.Close


    The "conn.open" line is line 10, and I've tried numerous combinations of coding the statement, with no change in the results.

    Can anyone give me a clue what I'm doing wrong? Appreciate it...

  2. #2
    Join Date
    Nov 2003
    Location
    Plymouth Meeting, Pa
    Posts
    3

    Re: 0x800A01A8 Object Required Message

    I found some other code to help define the data base connection:


    set conn=Server.CreateObject("ADODB.Connection")
    conn.Provider="Microsoft.Jet.OLEDB.4.0"
    conn.Open "c:\Inetpub\wwwroot\test1\survey.mdb"


    and this added records to my survey data base. Thanks to all that at least looked at my question!

  3. #3
    Join Date
    Jan 2003
    Location
    New York
    Posts
    160
    in between dim conn and conn.opn put this

    set conn = server.CreateObject("ADODB.connection")


    editted part : GMRunner2 beat me to the post
    Beyond Limitation

  4. #4
    Join Date
    Nov 2003
    Location
    Plymouth Meeting, Pa
    Posts
    3
    Originally posted by vextout
    in between dim conn and conn.opn put this

    set conn = server.CreateObject("ADODB.connection")


    editted part : GMRunner2 beat me to the post

    Vextout - Great minds are thinking alike!!!

Posting Permissions

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