Has anyone had experience of accessing Oracle 9 using VFP 6.
We've been quite happily accessing Oracle 8 using ODBC, connection strings and SQL Passthrough. We're now having to access Oracle 9 and we're getting the following error:
DIAG [S1000] [Oracle][ODBC][Ora]ORA-00932: inconsistent datatypes: expected
%s got %s
I believe we're getting a problem accessing the new timestamp field in Oracle.
Does anyone know whether it's because VFP 6 can't handle it, or is it an ODBC driver problem?