Arguments are of the wrong type...connecting to Access DB

T

thecubemonkey

I'm having an issue with connecting to an Access DB. I'm getting the
following error:

ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are
in conflict with one another.
/newsite/faq_test.asp, line 57

Can you look at the code in both my global.asa and ASP file to see if
the problem is my code or a setting on the server. Thanks in advance.

________________________________________________________________________
Global.asa
SCRIPT LANGUAGE="VBScript" RUNAT="Server">

Sub Application_OnStart()

Dim strConn
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\.....\.....
\......\faq.mdb"
Application("strConn") = strConn

End Sub

</SCRIPT>

_________________________________________________________________________
ASP File
<%
Dim rsFAQ
Set rsFAQ = Server.CreateObject("ADODB.Recordset")

rsFAQ.Open "FAQ", Application("strConn"), adOpenKeyset,
adLockReadOnly, adCmdText
Response.Write "DEBUG"

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 FAQs in the database!</p>" & vbNewLine
End If

rsFAQ.Close
%>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,969
Messages
2,570,161
Members
46,705
Latest member
Stefkari24

Latest Threads

Top