>>>I am using the same connection handle for the entire application life cycle (deklarit when application start) and i pass it when I am trying to execute the stored proc, so I suspect that the answer is once.
>>
>>Try to get it when you need it.
>
>Did you mean to recconect every time I need to exec a stored proc, get the connection handle (new every time) and pass it to sqlexec ?
Yes.
--sb--