Try to define the parameters in the same ordes as in the sp:
Brilliant. I knew it was something simple, should have thought of that. Thank you for your response, i can stop pulling my hair out now :-)
Should I take this as a rule of thumb - declare parameters in the order of the stored proc? Are parameters always read in this order? If so, are parameter names used at all? I'm generally quite careless as to the order that i declare parameters, and i would have expected this to bite me before...
