1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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