>>>>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.
That's the point, I want to use the same connection handle. When I am using each time a new connection handle (after a reconnect) it works. But I really don't understand why this work for the remote views of my application (after a tcp/ip reset) and they continue to work (I believe in the same connection handle) but the SPT loose the handle.
PS. Thanks for the quick response and sorry for bad English
----------------------------------------
Nikos Kiriakoulakos
Software Engineer
Dep. of Medical Informatics
Apollo Ltd.
Greece
----------------------------------------