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

Report · Jun 10, 2009

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

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

Report · Jun 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