Looking for database library using ODBC, possibly SOCI

[jetimms]

I'm very interested in finding a C++ database library that will allow me to query various database types.

I ran across a forum circa 2006 discussing SOCI and saw that it allows for ODBC connections.

I installed it and saw that the odbc portion of the library fails to build because there are no files for building odbc in the src/backends folder.

I also get the impression that the odbc capability is focused only on certain database types.

I would like to use it to hit MSSQL, Teradata, DBase, Foxpro, Access and Excel files, if possible; all of which I use DSN's to access.

Foxpro, the language, is what I currently use to do this, but I want to find a way to do this in C++.

Can anyone shed some light on SOCI or another solution that might help me?

By the way, I do lots of multiple outer, inner joins, nested selects and other complex queries, so that's why I want straight ODBC access.

Thanks.