Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00942 table or view does not exist

409812Dec 12 2003 — edited Dec 12 2003

Hi,

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?

I am using the same database user both for SQL Plus and my MFC app.

Please help me. I am clueless now.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 9 2004

Added on Dec 12 2003

#general-database-discussions

3 comments

210 views