Forum Moderators: mack

Message Too Old, No Replies

Have pity help me!! ADODB.Recordset (0x800A0BB9)

Arguments are of the wrong type, are out of acceptable range, or are in con

         

joan_0618

11:42 am on Oct 27, 2003 (gmt 0)

10+ Year Member




i received this error when i tried to browse my asp page:

Error Type:
ADODB.Recordset (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/My Web/sample/sample.asp, line 11

i might really be a silly one because i have this simple program and yet i cant run it successfully:

************
<% Option Explicit %>
<html>
<head><title>Frequently ****!
</title>
</head>
<body>
<ol>
<%
Dim rsFAQ
Set rsFAQ = Server.CreateObject("ADODB.Recordset")
rsFAQ.Open "FAQ", Application("strConn")
Do While Not rsFAQ.EOF
Response.Write "<li><b>" & rsFAQ("Question") & "</b>"
Response.Write "<p>" & rsFAQ("Answer") & "</p></li>"
rsFAQ.Movenext
loop
If rsFAQ.BOF then
response.write "<p>No FAQA</p>" & vbNewLine
end if

rsFAQ.Close

%>
</ol>
</body>
</html>

*********
the truth is i have just copied(or you might call STEAL) it from someone site (whoever you are im sorry im desperate to learn asp!)

i even have a global.asa (oh my gosh!i follow directions but still got no luck!)here's the code:
****
<SCRIPT LANGUAGE="VBScript" RUNAT="Server">

Sub Application_OnStart ()

Dim strConn
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:/Inetpub/wwwroot/My Web/sample/northwind.mdb"
Application("strConn")= strConn

End Sub
</SCRIP

******

what seems to be the error?...i have trouble running it with my browser (IE).

i feel like giving up already. i feel im really too slow to learn ASP codings...
i dont know if im too stupid or Imbecile(!?).

okay i have given youguys the scenario,please help me...

macrost

12:06 pm on Oct 27, 2003 (gmt 0)

10+ Year Member



joan_0618,
Maybe I'm blind but I don't see a SQL statement that is being executed. You need to use SQL to query a database. h*tp://www.w3schools.com/sql/default.asp

Mac

mattglet

7:14 pm on Oct 27, 2003 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



mac is right... you need to actually perform a SELECT, INSERT, UPDATE, or DELETE query on the database. follow the link mac provided.

-Matt