ADODB.Recordset error '800a0bb9'

Results 1 to 2 of 2

Thread: ADODB.Recordset error '800a0bb9'

  1. #1
    sachin Guest

    Default ADODB.Recordset error '800a0bb9'

    In my application I have a global connection & one global recordset. while Global recordset is open, i am trying to open a new recordset using the same connection on the same table. But it is giving above error. Error description is <BR>" The application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another"<BR><BR>Has anybody faced the similar problem ? what could be the solution ?

  2. #2
    Join Date
    Dec 1969

    Default RE: ADODB.Recordset error '800a0bb9'

    Post your code. This has happened to me when I&#039;ve written code in a hurry and referenced my recordset object incorrectly. For example, I may have<BR>Dim RS, RS1<BR>set RS = Server.CreateObject("ADODB.Recordset")<BR>RS.Open SQL, Conn,3,3<BR>set rs1 = Server.CreateObject("ADODB.Recordset")<BR>RS1.Open , SQL2, Conn,3,3<BR>Notice how I Dim the recordset object as RS1 and open it as RS1 but I set rs1 (lower case instead of RS1). Things like that cause that error, but you really need to post your code to get any helpful feedback.

Posting Permissions

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