Skip to main content
Known Participant
June 10, 2009
Question

ADODB.Command error '800a0bb9' Arguments are of the wrong type

  • June 10, 2009
  • 1 reply
  • 1117 views

Hello,

I am developing a page that is going to take some values from a database but I have this problem, I did a recorsed with dwcs3 and it is not working would you help please?

ADODB.Command error '800a0bb9'

Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

/web/ildwnew/default.asp, line 9

and my code is:

<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<!--#include file="Connections/webdesignportofolio.asp" -->
<%
Dim rs_categories
Dim rs_categories_cmd
Dim rs_categories_numRows

Set rs_categories_cmd = Server.CreateObject ("ADODB.Command")
rs_categories_cmd.ActiveConnection = MM_webdesignportofolio_STRING
rs_categories_cmd.CommandText = "SELECT * FROM sections ORDER BY sectionName ASC"
rs_categories_cmd.Prepared = true

Set rs_categories = rs_categories_cmd.Execute
rs_categories_numRows = 0
%><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">

This topic has been closed for replies.

1 reply

Known Participant
June 11, 2009

ok, I am going to answer my own question:

check and make sure the syntax is correct in the connections/webdesignportofolio.asp, I did it and it worked perfect