How long should you keep an ODBC SQL connection open?
===

A long-running application uses the MS C ODCB API to create and use SQL connections to an Oracel DB. The application was originally designed to establish an ODBC connection at startup and keep that connection indefinitely as the application runs, potentially for weeks or months.

We're seeing very infrequent cases where a connection suddenly dies and I wondered if that's because we're using them wrong, or if it's considered OK to hold a connection like this. Can anyone point me to some definitive information on the subject?