ADOxx database connectionADOxx database connectionRE: ADOxx database connectionPatrikhttps://www.adoxx.org/live/c/message_boards/find_message?p_l_id=&messageId=8575112017-05-18T10:42:34Z2017-05-18T10:42:08ZIt seems to have solved our problem. Thank you for the instructions and the help.Patrik2017-05-18T10:42:08ZRE: ADOxx database connectionMateusz Dziedzichttps://www.adoxx.org/live/c/message_boards/find_message?p_l_id=&messageId=8524862017-05-12T09:52:29Z2017-05-12T09:51:44ZDear Patrik,<br /> <br />Thank you for your message. This problem relates to the way the ODBC connection is establishing the connection to the SQL Server. By default, the connection is established using TCP-IP protocol, meaning that a network adaptor is required to have it running (even if not connected).<br /><br />In case the network connection is interrupted (e.g. standby-mode, hibernate, or Microsoft Windows Energy Management turning the adaptor off), ADOxx looses the connection to the database, and an error message is shown (adbsess-02).<br /> <br />To prevent such a behaviour, you can switch the protocol to non-network (e.g. Shared Memory). This can be achieved in the SQL Configuration Manager (installed as part of the SQL server) - see screenshot attached.<br />Change the protocol by activating one, and de-activating the other and then restart the SQL Service or your PC to be safe.<br /> <br />You can test if this step is operational by following the steps below:<br /> <br />a) Start ADOxx and login (also applicable to any tool developed using ADOxx)<br />b) Set the computer on STANDBY, or HIBERNATE respectively<br />c) Reactivate the computer: using Shared Memory the tool continues to run, with TCP-IP the connection is aborted and the error occurs.Mateusz Dziedzic2017-05-12T09:51:44ZRE: ADOxx database connectionPatrikhttps://www.adoxx.org/live/c/message_boards/find_message?p_l_id=&messageId=8516782017-05-11T15:04:57Z2017-05-11T15:04:39ZHi,<br /><br />we have a similar problem, where the connection to the database seems to be interrupted after a few minutes of inactivity (before the screen lock kicks in). We get an error "[adbsess-02] Due to a database exception the connection has been closed. No further databae access will be conducted in the current session. It is recommended to restart the application." The database (MS-SQL 2012) is installed locally on the same computer as the tool. How can we solve the problem?<br /><br />Best regards,<br />PatrikPatrik2017-05-11T15:04:39ZRE: ADOxx database connectionJudith Michaelhttps://www.adoxx.org/live/c/message_boards/find_message?p_l_id=&messageId=428172013-11-08T12:27:53Z2013-11-08T12:27:53ZHi Wilfrid,<br /><br />it seems that we don't have the problem any more - without changing anything. So thanks for your support option!Judith Michael2013-11-08T12:27:53ZRE: ADOxx database connectionWilfrid Utzhttps://www.adoxx.org/live/c/message_boards/find_message?p_l_id=&messageId=303472013-10-16T10:51:00Z2013-10-16T10:51:00ZDear Fadi,<br /><br />it seems that the time-out on the server end is set to a low value and therefore, not in-use ODBC connections are cancelled and closed after a certain period of time. Can you please provide us with a log file on this situation? To trace the interaction, please follow the steps below:<br /><br />a) Start Microsoft Windows ODBC Connection Manager (in case of a 64bit system, the ODBC Manager is available at c:\WINDOWS\SYSWOW64\odbcad32.exe otherwise it can be started from the Control Panel -> Administrative Tools<br />b) Enable Tracing (German: "Ablaufverfolgung"), specify a log file at a location of your convenience and start the log<br />c) Start ADOxx and wait for the disconnection to happen<br />d) Provide the LOG file to us, using faq@adoxx.orgWilfrid Utz2013-10-16T10:51:00ZADOxx database connectionFadihttps://www.adoxx.org/live/c/message_boards/find_message?p_l_id=&messageId=279852014-03-27T11:09:58Z2013-09-12T11:55:56ZWe face a problem of a disconnection between the ADOxx tool and the Adoxx database , when a user (client) does not use the tool for more than 4 minutesFadi2013-09-12T11:55:56Z