Questions on DisconnectedMode

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
brace
Posts: 227
Joined: Wed 14 Feb 2007 08:26

Questions on DisconnectedMode

Post by brace » Tue 27 Mar 2018 11:22

How TMSConnection's DisconnectedMode works?

How to check that it works from management studio process explorer? Should i see some users not online?

Why do you say
it may be useful for [...] operating in an unstable or expensive network
?

from https://www.devart.com/sdac/docs/work_d ... ctmode.htm

Stellar
Devart Team
Posts: 496
Joined: Tue 03 Oct 2017 11:00

Re: Questions on DisconnectedMode

Post by Stellar » Wed 28 Mar 2018 10:59

In disconnected mode a connection is opened for executing requests to the server (if it was not opened already) and is closed automatically if it is not required any more. If the connection was explicitly opened (the Connect method was called or the Connected property was explicitly set to True), it does not close until the Disonnect method is called or the Connected property is set to False explicitly. Therefore, in order for disconnected mode to correctly work, software connection to the server is not required.

Yes, you can check which users are active in Management Studio, for example, by calling the sp_who procedure. If you use disconnected mode, then only active sessions should be displayed in the user list.

Post Reply