From: chris.asaipillai@btinternet.com   
      
   I have a problem executing the following Stored Procedure from code.   
      
      
   The SP Text runs like this:   
      
      
   ALTER        PROCEDURE prc_InsertContractDirectStatus­_tmp   
    @var_ContractID  VARCHAR(50)   
      
      
   insert into tblContractAuditHistory (ContractID)   
    VALUES (@var_ContractID)   
      
      
   The VB code which calls the procedure runs like this:   
      
      
    Dim adoRs               As ADODB.Recordset   
       Dim adoCmd              As ADODB.Command   
       Dim adoPm               As ADODB.Parameter   
      
      
       Dim strContractID       As Variant   
       Dim strContractStatus   As Variant   
      
      
   Set adoCmd = New ADODB.Command   
      
      
       With adoCmd   
           .ActiveConnection = strConnection   
      
      
           Set adoPm = .CreateParameter("ContractID", adVariant, adParamInput,   
   , strContractID)   
           .Parameters.Append adoPm   
           .CommandText = "prc_InsertContractDirectStatu­s_tmp"   
           .CommandType = adCmdStoredProc   
      
      
           adoCmd.Execute   
       End With   
      
      
   However i get the following error message:   
   Type name is invalid.   
      
      
   Error code : -2147217872   
      
      
   Any ideas as to why this is happening?   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)