Nigel,

I would second entirely Lester's suggestion to go & have a look at
adodb. I am using it on a rather complex site & it performs really
well, I haven't had a problem yet with it.

For your problem, have you tried not to prepare, but manually build
the string with the SP & it's parameters and then execute it ? does it
make any difference ?

Didier