Hi

I'm new to ASP and hope someone can help me.

I have a web form that I want the fields to be entered into an Access database.

When I hit the submit key, I get this error message:

Microsoft JET Database Engine (0x80040E10)
No value given for one or more required parameters.
/test/test.asp, line 22

It's a really simple page, and I'm sure it's a simple error, but I can't get the user input into the database. When I hard code a ein and name into the database it works fine.

Thanks for any help!

t



<%

    Response.Expires = 0

    Dim objConn, objRS, strQ, strConn, strOutput
    Dim strConnection, strEin, strName

    strEin = Request.Form("ein")
    strName = Request.Form("name")

    Response.Write strEin & "<br/>"
    Response.Write strName

    Set objConn = Server.CreateObject("ADODB.Connection")
    objConn.Open strConnect

    strQ = "INSERT INTO Shippers (ein, name) VALUES "
    strQ = strQ & "(strEin, strName)"

    objConn.Execute(strQ)

%>

Hi there, tsparker...

you haven't used your variables, so this might help... ... however I see another thing, namely that the line... uses the variable strConnect, which is not declared or initialized anywhere (though perhaps in dataStores.asp).

Remember to close the connection.

Hope this helps

Jacob.