I have been trying to get an ODBC connection to a foxpro database to return data from inside a C program.

Using the SQL Log option when you set up an ODBC data source this is what I get as a failure code.


DIAG [01S01] [Microsoft][ODBC Visual FoxPro Driver]Error in row (0)

DIAG [01004] [Microsoft][ODBC Visual FoxPro Driver]Error: Column 1 ( wo_number ) (0)

The syntax of the command was correct. The SQLFetch returns that data exists, however, I don't see the data. (I asume that is because of the above.)

The C program is actually some one else's and I am unsure how it works.

Any ideas out there?

TIA,
Mike