General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
VFP 6 and Oracle 9. ORA-00932
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?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only