Help | Site Map
Connecting Tech Pros Worldwide
 
 
LinkBack Thread Tools
  #1  
Old October 3rd, 2008, 09:35 PM
thecubemonkey
Guest
 
Posts: n/a
Default Arguments are of the wrong type...connecting to Access DB

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
%>
 

Bookmarks

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over network members.
Post your question now . . .
It's fast and it's free

Popular Articles