Devart Forums

can I use disconnected mode in other thread or not? i'm creating and using the db connection in the other thread, but i still get disconnected after each command sent...? in main thread it works fine...

Yes, you can use disconnected mode in another thread.

Ludek wrote:i'm creating and using the db connection in the other thread, but i still get disconnected after each command sent...?

DisconnectedMode is used to open a connection only when it is needed for performing a server call and it is closed after performing the operation.

You write following in the help

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.

this was not true in sdac 4.70.0.46 (it has been corrected in 4.70.0.47) and it is still not true in 4.70.0.47, if the connection component is created and used in non-main thread.

so something should be corrected - the help (you should mention there, it is not valid for other threads) or sdac.

Please try to compose a small sample to demonstrate the problem and send it to dmitryg*devart*com.

i'll send it ASAP (i have now detected one next disconnection problem, that i must analyze first, i'll send you example then for both cases)

sorry, it is no problem with threads, just with sql errors. the connection gets disconnected, when sql error occurs (raiserror + rollback in trigger, incorrect syntax, anything).

Are you able to reproduce it? Or should I send a sample?

Thank you for information. We have reproduced the problem. The investigation of the problem is in progress. As soon as we solve the problem we will let you know.

Still no news?

We have fixed this problem. This fix will be included in the next SDAC build.