Hi everyone,
I have a basic FORM with a text field called
username. I am trying to submit the name to my database but get the same irritating error message every time. What am I doing wrong? This is becoming real frustrating.
I will appreciate help so much
Regards
Super007
[u]
The error: </u>
Error Type:
ADODB.Recordset (0x800A0E7D)
The connection cannot be used to perform this operation. It is either closed or invalid in this context.
/Formprocess.asp, line 15
Here is my code:
[u]
Form.asp</u>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>
<body>
<form id="form1" name="form1" method="post" action="Formprocess.asp">
<p>username <input name="username" type="text" id="username" /></p>
<p><input type="submit" name="Submit" value="Submit" /></p>
</form>
</body>
</html>
[u]
Formprocess.asp</u>
<% Option Explicit %>
<%
Dim objRS, strConnection, strusername
strusername = Request.Form("username")
strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Inetpub\wwwroot\Database\admin.mdb"
Set strConnection = Server.CreateObject("ADODB.Connection")
Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.Open "users", strConnection, adOpenStatic, adLockOptimistic, adCmdTable
objRS.AddNew
objRS("username") = strusername
objRS.Update
objRS.Close
Set objRS = Nothing
%>
Please help with Annoying error
, but now it gives me the following error...