1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

How to overcome this asp error : ADODB.Recordset (0x800A0BB9)

Discussion in 'ASP' started by bymbah, Apr 12, 2008.

  1. bymbah

    bymbah New Member

    Joined:
    Dec 12, 2006
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    0
    Hello guys, In my previous thread I forwarded the error quoted below

    "The Microsoft Jet database engine cannot find the input table or query 'Client'. Make sure it exists and that its name is spelled correctly.
    /Add_Client_Details.asp, line 13"

    But then my buddie suggested that I alter the code as given below:
    and this was my line 13 :
    'RS.Open "Client Details", DB, adOpenStatic, adLockPessimistic,adCmdTable

    Code:
     
    <!--#include file= "adovbs.asp"-->
    <html><head><title>Add_Client_Details</title>
    </head>
    <body>
    <%
    Dim DB
    
    Set DB = Server.CreateObject ("ADODB.Connection")
    DB.Mode = adModeReadWrite
    DB.Open ("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" + "C:\Inetpub\wwwroot\Marketing Database.mdb")
    Dim RS
    Set RS = Server.CreateObject ("ADODB.Recordset")
    RS.source = "Client Details"
    RS.activeconnection = objconn
    RS.CursorType = 2  
    RS.LockType = 3    
    RS.open
    RS.AddNew
    	RS.field("Company") =Request.Form("Cmnpny")
    	RS.field("Contact Name") =Request.Form("CnctName")
    	RS.field("Designation") =Request.Form("Dsgn")
    	RS.field("Address") =Request.Form("Cmpny")
    	RS.field("e-mail")=Request.Form("email")
    	RS.field("telephone number")=Request.Form("tel")
    RS.Update
    %>
    </body>
    </html>
    
    But now I am getting this error:

    ADODB.Recordset (0x800A0BB9)
    Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
    /Add_Client_Details.asp, line 15

    Can anyone suggest for me, how to overcome such an error.

    Thanx in advance.
     
  2. pradeep

    pradeep Team Leader

    Joined:
    Apr 4, 2005
    Messages:
    1,646
    Likes Received:
    86
    Trophy Points:
    0
    Occupation:
    Programmer
    Location:
    Kolkata, India
    Home Page:
    Try changing this line
    Code:
    RS.source = "Client Details"
    
    To
    Code:
    RS.source = "[Client Details]"
    
     
  3. bymbah

    bymbah New Member

    Joined:
    Dec 12, 2006
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    0
    HI pradeep;

    I changed the code according to your suggestion but the error still comes out.
     

Share This Page