Dear Patrik,
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).
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).
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.
Change the protocol by activating one, and de-activating the other and then restart the SQL Service or your PC to be safe.
You can test if this step is operational by following the steps below:
a) Start ADOxx and login (also applicable to any tool developed using ADOxx)
b) Set the computer on STANDBY, or HIBERNATE respectively
c) Reactivate the computer: using Shared Memory the tool continues to run, with TCP-IP the connection is aborted and the error occurs.
www.adoxx.org
