Error using Command object, append

Results 1 to 2 of 2

Thread: Error using Command object, append

  1. #1
    Kevin Guest

    Default Error using Command object, append

    Hello, can somebody point me in the right direction?<BR><BR>This code works fine when passing one parameter, but when I try appending 3...<BR><BR>I am getting the following error:<BR>Microsoft OLE DB Provider for ODBC Drivers error &#039 80004005&#039 <BR><BR>[Microsoft][ODBC Microsoft Access 97 Driver] Reserved error (-3033); there is no message for this error. <BR><BR>/auction97/aCourseAdd.asp, line 59 <BR><BR>from the following code:<BR> Set objCmd = Server.CreateObject("ADODB.Command")<BR> objCmd.ActiveConnection = strConnect &#039my connection <BR> objCmd.CommandText = "qryAddCourse"<BR> objCmd.CommandType = adCmdStoredProc <BR> <BR> strCourseNumber = Cstr(Request.Form("addCourseNumber")) <BR> strCourseName = Cstr(Request.Form("addCourseName"))<BR> strSchoolId = CInt(Request.QueryString("schoolId"))<BR> <BR> Set objParam = objCmd.CreateParameter("Required courseNumber",adVarChar,adParamInput,20,strCourseN umber)<BR> objCmd.Parameters.Append objParam <BR> Set objParam = objCmd.CreateParameter("Required courseName",adVarChar,adParamInput,20,strCourseNam e)<BR> objCmd.Parameters.Append objParam<BR> Set objParam = objCmd.CreateParameter("Required schoolId",adInteger,adParamInput,10,strSchoolId) <BR> objCmd.Parameters.Append objParam<BR> <BR> objCmd.Execute &#039this is the line with the error.<BR><BR><BR>I am using Access on NT.<BR>Thank you

  2. #2
    sachinK Guest

    Default RE: Error using Command object, append

    I am not sure but I think the length 10 seems to be pretty big in this st. Make it less and check<BR>Set objParam = objCmd.CreateParameter("Required schoolId",adInteger,adParamInput,10,strSchoolId) <BR>

Posting Permissions

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