Pass-through queries

[Rob.Mills]

Hey everyone,

I'm trying to use pass-through queries for the first time. Trying to access an Oracle server through Access. I've had tables linked from the server for a while so I know I can connect to it.

For my first query I tried something simple just to try it. I setup the connection string using the wizard just like when I'm trying to link to a table. Then for the SQL I put this:

SELECT POSTED_TO_HISTORY_DATE
FROM PROD2_LOAN_HISTORY;

I get the error that the call failed. I've attached the error.

But I can open the table directly just fine so I don't know where I'm going wrong here.

 

[MattS]

I've checked a couple of the pass-through queries I use (to interegate a Sybase database) and I think you have to add dbo to the table name, i.e. dbo.PROD2_LOAN_HISTORY

 

[Rob.Mills]

I tried your suggestion but got the same error. Is it possible I need to use something other than dbo for an Oracle db?

 

[MattS]

To be honest, I'm not really sure. The pass-through queries I use were written some time ago, and I don't know (remember!) too much about them.

Sorry I couldn't be of any help.

 

[FoFa]

make sure the userid and password are correct.
You MUST specify the owner.tablename as
SELECT COUNT(*) FROM OWNER.MYTABLE
Specify the DSN you are using in the properties of the query.