Ora-00942 Error on PTQ

[djo2237]

I'm attempting to create a pass-through query (PTQ) to my local Oracle XE instance via OBDC. When I run my PTQ I get an Ora-00942 error "table or view doesn't exist". I have ensured that the table does exist and the user I'm connecting as can Select data from the table using SQL-Plus. The statement I'm using in the PTQ runs fine in Sql-Plus.



I have verified my connection string is correct by successfully running:

SELECT sysdate from dual;

If I try to link the table, I can browse to it and create the link. When I try to open it I get an Ora-00942 error again.

I'm thinking it is a security issue on the database side but I'm not certain. I would appreciate any and all help

[rpeare]

When you link the table into access can you open the table with no trouble?

If you can it *may* be a problem with reserved words

Try linking your table but giving it a different name like tblDual and when you reference your field do something like [tblDual]![sysDate] as SD.

I don't use oracle so I'm afraid I'm not much help but it seems odd that you can link the table but not get a query run on it.

[djo2237]

I can create a linked table but cannot open it to view the data. Just like the PTQ it returns the Ora-00942 error.

[rpeare]

I think you're right that it's a security issue. I know when you link a SQL table you can choose to use windows authentication which requires you to have a user set up on the SQL server with the exact same login name/password and also have that user set up with the permission to modify/view the database within SQL itself. I haven't used orcale links but if it's similar you may have to follow the same sort of procedure.