<div>
Just a thought -- I'd be a little bit careful about using MFC's DAO classes. We use it extensively in our VC 6.0 vintage project work (DAO is still the fastest database access method Microsoft supports). However, in porting to VS .Net 2003 (VC7), MFC's DAO classes keep popping up deprecated warnings that worry me about the future of DAO in the MFC framework. I know that Microsoft has been pushing people to move from DAO to ADO or OLEDB for years now but haven't succeeded in killing off the DAO API. Because of this we are evaluating whether to move our MFC DAO classes over to OLEDB in VC7.
</div>


Just a thought -- I'd be a little bit careful about using MFC's DAO classes. We use it extensively in our VC 6.0 vintage project work (DAO is still the fastest database access method Microsoft supports). However, in porting to VS .Net 2003 (VC7), MFC's DAO classes keep popping up deprecated warnings that worry me about the future of DAO in the MFC framework. I know that Microsoft has been pushing people to move from DAO to ADO or OLEDB for years now but haven't succeeded in killing off the DAO API. Because of this we are evaluating whether to move our MFC DAO classes over to OLEDB in VC7.

<div>
<div class="content wysiwyg-content">
I'm updating an older program, and need to add ODBC Support for Oracle, Sybase and SQL Server. The code is using DAO for database access, and I would like to keep that infrastructure. <br />
<br />
What is the preferred way of connecting/querying/updati<wbr />ng records in C++ using DAO? <br />
<br />
Thanks
</div>
</div>


I'm updating an older program, and need to add ODBC Support for Oracle, Sybase and SQL Server. The code is using DAO for database access, and I would like to keep that infrastructure. 

What is the preferred way of connecting/querying/updating records in C++ using DAO? 

Thanks

DAO - Database Access compatibility with Oracle, Sybase, and SQL Server through ODBC

C++ is an intermediate-level general-purpose programming language, not to be confused with C or C#. It was developed as a set of extensions to the C programming language to improve type-safety and add support for automatic resource management, object-orientation, generic programming, and exception handling, among other features.