Results 1 to 10 of 10
  1. #1
    Join Date
    Nov 2003
    Location
    India
    Posts
    28

    Red face Unanswered: ORA-00942 table or view does not exist

    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?

    Please help me. I am clueless now.

    Thanks

  2. #2
    Join Date
    Nov 2002
    Posts
    833
    are you using different users from your application and when connecting though sqlplus ???
    maybe from sqlplus you use the schema-owner who obviously has every right in that schema.

  3. #3
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    There were problems with 8.1.7.0 ODBC drivers ... Try the
    8.1.7.4 ODBC drivers ... Also, ensure that you are actually logging
    into the database with the same user as thru SQLPlus...

    HTH
    Gregg

  4. #4
    Join Date
    Nov 2003
    Location
    India
    Posts
    28

    Re:

    Gregg, I am using the same database user for both SQl Plus and in my MFC too.

    I still do not know why this is happening.

    Sateesh.

  5. #5
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    I would download the 8.1.7.4 odbc drivers from Oracle and give
    that a try ...

    Gregg

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    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";.

  7. #7
    Join Date
    Nov 2003
    Location
    India
    Posts
    28

    Re:

    Gregg, I tried downloading the version you said. I do not find any setup with it.

    Sateesh.

  8. #8
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    You run the Oracle Installer and point to the location of the ODBC
    for the installation ...

    HTH
    Gregg

  9. #9
    Join Date
    Nov 2003
    Location
    India
    Posts
    28

    Re:

    Gregg,

    I installed 8.1.7.4 odbc driver , but still I am having the same problem.

    Please help me.

    -Sateesh.

  10. #10
    Join Date
    Nov 2003
    Location
    India
    Posts
    28

    Re:

    Gregg, Sorry there was a problem in my app. I found it when I was looking at the ODBC log trace. Thanks for the help.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •