We are having sporadic connection issues with one of our ODBC connections. Does someone have some good ideas on how to log and troubleshoot this connection from within our solution? Perhaps even to the point of being able to detect a problem and proactively send an email? Are there ways to getting an error code or message out of the connection?
The DSN configuration on the server has a checkbox for logging driver stats, and that IS checked, but there is no log file actually being generated.