MS Oracle ODBC failure in Access 07

[Joseph Goldman, IT Manager]

We have been using Access 2003, with the MS Oracle ODBC connector V2.0, to
run queries against our Oracle database - for over 8 years. Our workstations
are Win XP, with the latest service pack and patches.

Recently, we've been moving our users to Access 2007. We are still using the
same MS-supplied Oracle connector; to run the Access 2003 queries. Now - some
Access 2007 users can run the queries just fine, while most can no longer run
the queries. They get the error:

"ODBC-Connection to database failed" (Error 3151)

We have checked the ODBC definition, and it's fine. We've also reinstalled
the MS Oracle ODBC connector; but still these users get this connection error.

Anyone have any suggestions on whatelse we can try ??

Thank you ...

 

[Arvin Meyer [MVP]]

Try creating a Trusted Location and moving the database into it. Also check
your references. Sometimes error messages are not accurate.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Joseph Goldman, IT Manager" <Joseph Goldman, IT
(e-mail address removed)> wrote in message
news:[email protected]...

 

[Joseph Goldman, IT Manager]

Thank you for the suggestion Arvin. We created a Trusted Location, put the
database file into it, but still the queries won't run. Now, Access 2007
hangs and we have to CTRL-ALT-DEL it.

Also, we uninstalled the Oracle 8 Client - reinstalled it - and tried. This
worked on one computer, but not on any others.

Frustrating !!!!
--
JOSEPH GOLDMAN
IT SYSTEMS MANAGER
Physical Facilities
Binghamton University
Binghamton, NY 13902-6000

 

[Arvin Meyer [MVP]]

Frustrating is par for the course with Oracle.

See if you can find a Microsoft client or ODBC driver for Oracle. That's
worked on occasion. Another thing to try is to disconnect the Oracle links,
compact the Access front-end a few times, then reconnect it.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com