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.