If you have trouble getting the results you want when programming your ODBC program, test it with a different data source. This will help you determine if the problem is with your program, or with the data source connection itself.