Do you still feel that it's blowing up on the CommandType value? What value are you giving it? What do you have the variable adCmdStoredProc defined as or where are you getting the value from?
-Mike
>Still not working. I've removed all of the prameters from the proc and from the asp call. Now it just calls a proc that inserts a record.
>Even with no parameters it's still giving me the same message. i've tested the stored proc from query analyser and it works fine.
>
>Phil.