Joe,

Thanks for the advice, unfortunately i had already allowed execute permissions to the user on the stored procedure.

But the plot does thicken, i have ran my application in the vb6...