October 13th, 2000, 06:26 PM
|
|
Contributing User
|
|
Join Date: Dec 2002
Posts: 14,575
Time spent in forums: < 1 sec
Reputation Power: 22
|
|
|
ADODB.Recordset error
<i><b>Originally posted by : dale (dale@duluth.com)</b></i><br /><br />Hi all<br />I keep getting the error:<br /><br />ADODB.Recordset error '800a0bb9'<br />Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. <br />/InfectionControl/Beta 10 12 00/DisplayIll.asp, line 22 <br /><br /><br />On this Page:<br /><br /><%@ Language=VBScript %><br /><HTML><br /><BODY><br /><br />Hello <BR> <BR><br /><br /><%<br />'Dim strSick, strFLN, strEID<br />'strSick = Request.Form("Sickness")<br />'strFLN = Request.Form("EmpFirstLast")<br />'strEID = Request.Form("Number")<br />'Response.Write(strSick) & "<BR>"<br />'Response.Write(strFLN) & "<BR>"<br />'Response.Write(strEID) & "<BR>" <br /><br /><br /><br />Dim oRS4<br />Set oRS4=Server.CreateObject("ADODB.Recordset")<br />oRS4.Open "tblIllness", "DSN=TestITDatabase" ,adOpenKeyset ,adLockOptimistic<br />oRS4.AddNew<br />oRS4("EmployeeID")=Request.Form("Number")<br />oRS4("Sickness")=Request.Form("EmpFirstLast")<br />oRS4.Update<br />%><br /><br /></BODY><br /></HTML><br /><br />I have played around with the lock and curser types as per some example I have But no luck.<br />I am using MS Access.<br /><br />Thanks Dale<br /> <br /><br /><br /><br /><br /> <br />
|
ASP Free Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
