Forum Moderators: mack
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...