>>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 ?
----------------------------------------
Nikos Kiriakoulakos
Software Engineer
Dep. of Medical Informatics
Apollo Ltd.
Greece
----------------------------------------