<div>
You should connect to the database source first and on success pass the CDatabase object to the constructor of CRecordSet to use that established connection.<br />

</div>


You should connect to the database source first and on success pass the CDatabase object to the constructor of CRecordSet to use that established connection.


<div>
<div class="content wysiwyg-content">
I am using an ODBC connection to an SQL Server Database in my MFC app (VC++ 5.0 Enterprise). My program is running overnight, so it has to operate totally unattended. I need a way of trapping the error if the SQL DB is down and writing an error message to my app's log file.<br />
<br />
How and where can I test if the ODBC connection was successful or failed ? In other words, where to test the result of the GetDefaultConnect procedure ?<br />
<br />
Thanks a lot,<br />
<br />
Derek
</div>
</div>


I am using an ODBC connection to an SQL Server Database in my MFC app (VC++ 5.0 Enterprise). My program is running overnight, so it has to operate totally unattended. I need a way of trapping the error if the SQL DB is down and writing an error message to my app's log file.

How and where can I test if the ODBC connection was successful or failed ? In other words, where to test the result of the GetDefaultConnect procedure ?

Thanks a lot,

Derek

How to catch ODBC failure ?

Kernel and system programming is the process of creating the software necessary for a computer or device to function and operate other programs. Some operating systems (such as Microsoft Windows) are proprietary, but others, such as the various Linux distributions, are open source.