UniDAC MS SQL Server disconnection problem
Posted: Tue 27 Aug 2013 10:42
Hello.
Recently I started to use UniDAC components in Delphi 2010 IDE to develop database applications
for video surveillance systems. I wrote a small multithreaded application for connection to
database and reading data. Each UniConnection has it's own thread in which it connects
to database and UniQuery retrieves data. I noticed, that if I establish a connection to
Microsoft SQL Server (or to MS SQL Server Express) while connection not established I cant
disconnect it and free TUniConnection and thread.
How can I disconnect and free a TUniConnection "instantly" and my connection thread while connection to Microsoft SQL Server is in process?
Decreasing a connection timeout doesnt help.
Thanks.
Recently I started to use UniDAC components in Delphi 2010 IDE to develop database applications
for video surveillance systems. I wrote a small multithreaded application for connection to
database and reading data. Each UniConnection has it's own thread in which it connects
to database and UniQuery retrieves data. I noticed, that if I establish a connection to
Microsoft SQL Server (or to MS SQL Server Express) while connection not established I cant
disconnect it and free TUniConnection and thread.
How can I disconnect and free a TUniConnection "instantly" and my connection thread while connection to Microsoft SQL Server is in process?
Decreasing a connection timeout doesnt help.
Thanks.