ADO error 3421 - Application uses a value of the wrong type

I am trying to pass some values to a sql server 2k stored proc and am getting this error:
3421 - Application uses a value of the wrong type for the current operation.

It does not make sense to me because all of the other variables seem to work fine except this varchar(64) variable here is the code.

stored proc:
CREATE PROCEDURE dbo.addnewpermit

  @p_PERMIT_ID                     numeric,
  @p_PROJECT_NUMBER      numeric,
  @p_PROJECT_NO_OCC       numeric,
  @p_PERMIT_TYPE_ID          numeric,
  @p_PERMIT_LETTER_DATE_SENT      datetime,
  @p_PERMIT_LETTER_SENT_TO         varchar(64),
  @p_PERMIT_LETTER_SIGNEE          numeric,
  @p_PERMIT_LETTER_AUTHOR          numeric,
  @p_PERMIT_RESPONSE_DATE          datetime,
  @p_PERMIT_GRANTED                varchar(3),
  @p_PERMIT_MONEY                  numeric,
  @p_PERMIT_COMMENTS               varchar(866),
  @p_PERMIT_EXPIRATION_DATE        datetime

as

vb code:

With inscom
            .ActiveConnection = cnSQL        
            .CommandType = adCmdStoredProc      
End With
            inscom(0) = pp_permit_id
            inscom(1) = pp_project_number
            inscom(2) = 1
            inscom(3) = pp_permit_type_id
            inscom(4) = pp_permit_letter_date_sent
            inscom(5) = pp_letter_sent_to
            inscom(6) = pp_letter_signee
            inscom(7) = pp_letter_author
            inscom(8) = pp_response_date
            inscom(9) = pp_granted
            inscom(10) = pp_money
            inscom(11) = pp_comments
            inscom(12) = pp_permit_expiration_date

            inscom.Execute

It runs to the point where it executes the "inscom(5)"= statement. The value here is some text like "joe smith".

Any ideas?


Start Free Trial