ODBC error on pass-through query (1 Viewer)

[Isaac]

Here is a page that may help:

Schema Object Names and Qualifiers

docs.oracle.com

I would start simple. Test a very small bit of SQL with different identifier styles until one works:

select * from "schema"."table" where rownum<5

(note, in that example I just took a guess at what one of your 'identifier styles' might be if you wanted to test it, you may have to test a few).

You may need to find out from your DBA what is the 'safest' (and probably most verbose) way of selecting from that view in the identifier portion