activex_data_objects thread: Multiple-step OLE DB operation generated errors. Any ideas?
I am getting this error
Multiple-step OLE DB operation generated errors. Check each OLE DB status
value, if available. No work was done.
It is caused by having a stored procedure with an input parameter of
uniqueidentifer. If I change this to a varchar it doesn't happen. I can do
this to get round the problem but I would like to know if anyone has a
proper solution to this. From the documentation I've seen I should be able
to use uniqueidentifer as an input parameter. I've tried doing
microsofts 'fix' but this doesn't help.
Any ideas
Cheers
Ian