Question w/executing Stored Procs

Results 1 to 2 of 2

Thread: Question w/executing Stored Procs

  1. #1
    Join Date
    Dec 1969

    Default Question w/executing Stored Procs

    Greetings, all...<BR><BR>I&#039m trying to work my way through the SAMS ASP 2.0 Unleashed book and stuck with Chapter 14: Using ASP&#039s with DB: Working with the Command Object.<BR><BR>Their example code contains the following statement:<BR><BR>MyCommand.CommandType = adCmdStoredProc<BR><BR>I&#039ve copied this letter for letter into my asp page, and get the following error when running it:<BR><BR>ADODB.Command error &#039 800a0bb9&#039 <BR><BR>The application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another. <BR><BR>/Bottlenose_Test/delete_me1.asp, line 13 <BR><BR>Here is the code in question:<BR>set objCommand = server.CreateObject("ADODB.Command")<BR>set objCommand.ActiveConnection = objConnection<BR><BR>objCommand.CommandType = adCmdStoredProc<BR>objCommand.CommandText = "checkAuthor"<BR><BR>set myParam = objCommand.CreateParameter("ReturnCode", adInteger, adParamReturnValue)<BR><BR>I&#039m not sure where to be looking to solve this thing. If there&#039s anybody out there that can help, I&#039d appreciate it!<BR><BR>/ric

  2. #2
    Join Date
    Dec 1969

    Default RE: Question w/executing Stored Procs

    Did you include

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts