Connecting to more than 1 oracle table through different ODBC DSN's

[dpfeffer]

Hi
I have an Access97 datbase with a linked table to an oracle table
through ODBC.

In the same Access97 database I have another table linked to a
different oracle table through a separate ODBC DSN.

When I first open the database and try to open Table1, I am prompted
for username/password and then the table opens in Datasheet view.
However, if I then try to open Table2, I am prompted for
Username/password, but then I get an "ODBC--Connection to 'DSN Name'
failed" error. (username/passwords are valid).

If I open Table2 first, it is successful, but then I can't open
Table1. I have tested this on about 6 PCs, both tables open
successfully on 4 of them, but not on 2.

Has anyone come across this before...

I am using Oracle ODBC Driver 2.05.03.01. I have even tried loading
MDAC v2.7 but this doesn't appear to help.

Thanks
David