Also, if you're calling a SQL Server stored procedure, I believe that the ADO parameter name must match the stored proc parameter name. This means that the names should start with a @.

-Mike

>I sussed that so I changed them to adNumeric, adChar, & adChar. Which is what they are in the stored proc but it still gives the same error message.
>
>Phil