You can use the Quick Test (\Samples\Odbc\Quiktest\Quiktest.c) as a starting point for both writing your own auto tests and testing your driver. The Quick Test calls each ODBC function and verifies that it returns the expected code. Next, it calls SQLGetDiagRec until that function returns SQL_NO_DATA, verifying that the expected SQLSTATEs are returned. Finally, for some functions, it checks if the function returns the expected data.
Note The Quick Test is not an ODBC acceptance or compliance test. It is a starting point for your testing.