CDatabase vs ADO - Advice please

[rchandr3]

Hiya,

I am designing a MFC Application. I have been using CDatabase for years, but now people say ADO is future. Whats the advantage of ADO over CDatabase and is that worth the chunks of code changes I have to make?

Thanks a lot,


Cheers,

Ravi

 

[PerFnurt]

ADO is the future? In opposition to ODBC or what?

Since CDatabase pretty much just encapsulates ODBC you can stick to it since you're familiar with that framework in C++.

>advantage of ADO over CDatabase

Well, CDatabase is a framework in C++ so if you for example were to communicate with the DB from another language, say VB, CDatabase is rather useless.

However, the difference isn't that big (both deal with dabatabase, queries, recordsets etc), if you know how things work with CDatabase in C++, you can rather easily figure out how a similar thingie would look using ADODB in VB/JScript/Whatever.

/Per

_{"It was a work of art, flawless, sublime. A triumph equaled only by its monumental failure."}