>Dear Nadya,
>
>Thank you for your reply .... According your question, I try to change the program without using "CInt and CStr" and remove nRec variable. But the error message still showed when execute the program. I don't know how to debug the store procedure, therefore, I can't know what value pass into store procedure. Do you know how to debug the store procedure? Do you any idea to solve the problem? 1000 Thanks!!
>
>Best Regards,
>
>Justy Chow

Hi Justy,

I'm also a newbie, but I would go to SQL Server and try execute(mySp, parameters). Check out the Help on this.