Message
From
10/02/2017 01:25:36
To
09/02/2017 07:34:45
General information
Fórum:
Visual FoxPro
Category:
Bases de dados, Tabelas, Views, Indices e SQL
Título:
Environment versions
Visual FoxPro:
VFP 9 SP2
Database:
MS SQL Server
Miscellaneous
ID da thread:
01647688
ID da mensagem:
01647815
Views:
49
>>>>Someone knows a situation where SQLDISCONNECT () does not disconnect the session?
>>>
>>>Maybe the handle you specify is out of scope?
>>>
>>>Maybe there is an asynchronous query running which has not finished? (not tested)
>>
>>good point!
>
>Not sure if this fits in here, but what if sqlIdleDisconnect() was used... Would that reconnect? Or could it happen in a scenario where
>1. a real (physical or any other external cause) disconnect happens
>2. the app issues a disconnect()
>3. something else in the app needs the handle, the idle disconnect detects that there's no connection, reconnects.
>
>I've seen some uses of this idle disconnect, but it's not the code I wrote, nor have I tested it myself, so I'm only guessing here.
the question is this:
in such cases after a SQLDisconnect() the session is still alive?
>>>
>>>Maybe the handle you specify is out of scope?
>>>
>>>Maybe there is an asynchronous query running which has not finished? (not tested)
>>
>>good point!
>
>Not sure if this fits in here, but what if sqlIdleDisconnect() was used... Would that reconnect? Or could it happen in a scenario where
>1. a real (physical or any other external cause) disconnect happens
>2. the app issues a disconnect()
>3. something else in the app needs the handle, the idle disconnect detects that there's no connection, reconnects.
>
>I've seen some uses of this idle disconnect, but it's not the code I wrote, nor have I tested it myself, so I'm only guessing here.
the question is this:
in such cases after a SQLDisconnect() the session is still alive?