Accessing database using MFC

[Argo]

I have 2 databases Oracle and MySQL, running on different hosts. I need to write an MFC program that will connect to either one of those databases and send a bunch of rather complex SQL queries. Now, as both ODBC and DAO oversimplify things a lot by providing recordsets and stuff like that. In other words, they both are optimized towards simple search queries and traversal. I, on the other hand, need something as simple as PHP, that will work from within MFC program. Does anybody know how I can accomplish that?

 

[MetalCat]

Write them as dB functions and call them using ODBC, takes the heat of the dB engine as the functions will be optomised and the calls eaiser.

And it can't be done with Microsoft doc's any of this.

Are the dB's designed well ?