We have tried to use an environment action to set HVR_TCP_KEEPALIVE to 30 and to set HVR_ODBC_CONNECT_STRING_ADD to “QUERYTIMEOUT=0” without any success. We have not yet tried to use SQL_PREPARE_TIMEOUT. What is the purpose of that setting?
Oops! Looks like you're using an outdated browser...
It appears you are still using Internet Explorer. Support for IE has been discontinued by Microsoft, and many features of our site may not display or work properly.
Please upgrade (it's free!) to Edge, Chrome, Safari, or any modern browser for the best user experience.