For an example-based introduction to using ODBC from C, refer to the Easysoft tutorial ODBC from C tutorial (part 1) — getting started.
Easysoft also recommend that you refer to the ODBC Programmer's Reference and other ODBC documentation provided on the Microsoft web site.