1 Reply Latest reply: Jun 11, 2009 10:10 AM by I Love Doing Websites RSS

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

    I Love Doing Websites Community Member

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