probs on asp_sql command

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • MATTXtwo
    New Member
    • Sep 2006
    • 83

    probs on asp_sql command

    Code:
    dim val 
    set rm = Server.CreateObject ("ADODB.Command") 
    rm.ActiveConnection=OBJdbConnection 
    rm.CommandText="exec get_user" 
    
    rm.Parameters.Append rm.CreateParameter("RETURN",adInteger,adParamReturnValue,4) 
    
    rm.Parameters.Append rm.CreateParameter("@user_id",adVarChar,adParamInput,8,NoStaf) 
    
    rm.Parameters.Append rm.CreateParameter("@pwd",adVarChar,adParamInput,12,Pwd) 
    rm.Execute 
    val=rm.Parameters("RETURN").Value


    ------------------------------------------------------------------------------------------------------------------ADODB.Command error '800a0bb9'

    Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

    /Intranet/MainVal2.asp, line 14
    Last edited by MATTXtwo; Sep 25 '08, 12:03 AM. Reason: forgot code tags
  • DrBunchman
    Recognized Expert Contributor
    • Jan 2008
    • 979

    #2
    I think this is a problem with your parameters. What parameters is your stored procedure expecting and what types are they?

    Dr B

    Comment

    Working...