pcsoft.us.windevCopyright 2026, PC SOFT10 Apr 2018 10:17:00 Z30 Mar 2018 21:05:00 ZHi, I facing a situtation where HOpenConnection() does NOT return false even when there is no connection possible to the database. It look like some kind of cache problem or something like that. First time I open a connection I run some querys and so to present info to users on a big screen Then I close the connection Every 30 seconds the info is refresh using a timer. Again, HOpenConnection, show data, HCloseConnection. Now I unplug the network. Wait for the next timer loop and then HOpenConnection still returns TRUE, indicating the connection is open?!?! Also a HOpen(Tbl_License) returns TRUE. However using the first real data access with HReadFirst there is finally an error. See below. Why doesn't HOpenConnection return FALSE ?? native SQLSERVER access error. Error Number = 117 Unable to open or read file. Error 80004005 returned by SQL Server Description: Deferred prepare could not be completed. SQL State: SQL Error Number: 0 Sub-error #1 Description: Unable to open a logical session SQL State: 08S02 SQL Error Number: -1 Sub-error #2 Description: SMux Provider: Physical connection is not usable30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65077-wd22-sqlserver-reconnect/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65077-wd22-sqlserver-reconnect-65174/read.awp10 Apr 2018 10:17:00 ZHi Derek, finally had some time to test this and it seems to help! This function does some black magic with the variable inde…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65077-wd22-sqlserver-reconnect-65174/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65077-wd22-sqlserver-reconnect-65174/read.awpWD22 - Sqlserver reconnectguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65077-wd22-sqlserver-reconnect-65119/read.awp3 Apr 2018 15:15:00 ZArie Have you tried VariableReset(MyConnection) before HOpenConnection() ? VariableReset() sets all values of the variable…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65077-wd22-sqlserver-reconnect-65119/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65077-wd22-sqlserver-reconnect-65119/read.awpWD22 - Sqlserver reconnectguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65077-wd22-sqlserver-reconnect-65108/read.awp2 Apr 2018 20:02:00 ZWell, detecting the connection is broken or lost is not the problem. At the first point data is really read, you will get an err…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65077-wd22-sqlserver-reconnect-65108/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65077-wd22-sqlserver-reconnect-65108/read.awpWD22 - Sqlserver reconnectguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65077-wd22-sqlserver-reconnect-65082/read.awp30 Mar 2018 22:32:00 ZHello Arie I ran into this year's ago I ended up opening a socket first to make sure there is a connection available then clo…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65077-wd22-sqlserver-reconnect-65082/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65077-wd22-sqlserver-reconnect-65082/read.awpWD22 - Sqlserver reconnectguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65077-wd22-sqlserver-reconnect-65081/read.awp30 Mar 2018 21:34:00 ZHi Arie, I'm GUESSING here... But based on the error message content: "Deferred prepare..." - "...Physical connection is not …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65077-wd22-sqlserver-reconnect-65081/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65077-wd22-sqlserver-reconnect-65081/read.awpWD22 - Sqlserver reconnect