Plain ODBC API, just found it:
Dr. Dobb's | A Lightweight C++ Wrapper for Microsoft's ODBC API | January 1, 2002
C# is definitly the easiest way, but I don't know the requirements. As far as COM/ADo goes you just have to follow the pattern described in the samples, no need to learn COM