944,111 Members | Top Members by Rank

Ad:
  • ASP Discussion Thread
  • Unsolved
  • Views: 15044
  • ASP RSS
Jun 21st, 2006
0

asp problem ADODB.Recordset error '800a0bb9'

Expand Post »
I have a problem entering data into my database using asp and vb scripting languages
web site address = http://www.ilizarovgrp.co.uk/
i have tried adding a advobs inc file but the page will not display once this is added this may be because of my server options but i thought asp was a free usage language.
I can already read stuff from the database which is a access file but cannot enter info using the adLockOptimistic option in the connection because i keep getting the error (above in title) which says

Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

Line 49 highlighted below

if anyone has any advice or can say why i cannot add the advobs inc file to my page i would be greatful. The web host is fasthosts and i am using a simple asp server system along with access file storage database.




<%@Language=VBScript%>
<% Option Explicit %>



<table width="701" border="1" cellpadding="0" cellspacing="0" bordercolor="#000000">
<tr>
<td width="127"><font color="#993399" size="+2"><strong>Title</strong></font></td>
<td width="233"><font color="#993399" size="+2"><strong>Description</strong></font></td>
</tr>
<%
Dim objConn
Dim adlockoptimistic
Dim adCmdTable
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionString="DRIVER={Microsoft Access Driver (*.mdb)};" & _
"DBQ=" & Server.MapPath("\ilizarovdata.mdb")
objConn.Open
Dim objRS
Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.Open "ilizarov", objConn, , adLockOptimistic, adCmdTable

objRS.AddNew
objRS ("name")= Request.Form ("ilizarname")
objRS ("comment") = Request.Form ("fmcomments")
objRS.Update

objRS.MoveFirst
Do while Not objRS.EOF
Response.Write"<tr><td>"&objRS("name")& "</td>"
Response.Write "<td>"&objRS("comment")& "</td>"
objRS.MoveNext
loop
objRS.close
Set objRS = Nothing
objConn.Close
Set objConn = Nothing
%>
</table>
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
neillly77right is offline Offline
1 posts
since Jun 2006
Jun 21st, 2006
0

Re: asp problem ADODB.Recordset error '800a0bb9'

Hello,
You havent entered any cursor type for the recordset. You try the following line.
objRS.Open "ilizarov", objConn,adOpenDynamic , adLockOptimistic, adCmdTable

I think by default it take adOpenForwardOnly cursor tyep which conflicts if you try to enter the record in the data base using the add method.
Here is the the general form of opening a recordset.

objRS.Open source, connection, [cursortype], [locktype], [options]

Reputation Points: 9
Solved Threads: 1
Junior Poster in Training
msaqib is offline Offline
91 posts
since Sep 2004

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in ASP Forum Timeline: Small date problem
Next Thread in ASP Forum Timeline: ASP File Publish in PHP server





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC