Query works one PC, but not another (Oracle tables)

[nhtennispro]

I am using Access 2003 to link 2 Oracle databases together for a rather complicated (20 tables) query. It works on my PC, but doesn't work on other PC's that are as every bit as powerful as mine. I am not using pass through queries to the Oracle dbs as views that I would need have not been written.

<b>Here are some of the other characteristics:</b>
1.When I run query there is always activity in my task manager from execution to completion, but in others PC the activity stops after 1 second.

2. ODBC settings (fetch size, etc.) are the same

Its not a complexity of query issue, because I can have the same phenomena happen with only 5 Oracle tables.

The final Oracel error that I get is 01013, a time out error. But that is not the real cause, IMHO, as it just times in 60 seconds after it quits working 59 seconds prior.

Thoughts

 

[GingerR]

Can you just open a view on it's own on another pc successfully?



Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html