Unanswered: ORA-00942 table or view does not exist
I am able to run queries (select, update and delete) on a particular oracle 8i database through my SQL*Plus utility.
But when I am executing even a select query using CDatabase class and DAO in my MFC app, it is saying "ORA-00942 table or view does not exist". When I referred the error in some document, it said you may be not having sufficient permissions, but I am able to execute the same queries through SQL*PLUS though. I am using ORACLE ODBC 8.01.07.00 driver. Is it something to do with it?
A frequent problem between ODBC & Oracle is that by default Oracle "assumes" TABLE_NAME & COLUMN_NAME are always upper case. Frequently in ACCESS or SQLSERVER tables have mixed case names. One way around this is to use double quote marks around the table name; such as SELECT * FROM "Employee";.