Hi there,

I have some legacy VB6 code that uses ADODB commands to execute stored procedures in an SQL database.

It's suddenly stopped working. On investigation, it seems that the parameters are being created automatically as soon as I specified the CommandName (i.e. the stored procedure). Our existing code adds the parameters manually so now we've ended up with twice as many parameters and the code execution obviously fails.

So, I'm wondering if anyone else has experienced this? Is it something in Windows that has changed recently?