MS Oracle ODBC failure in Access 07

  • Thread starter Joseph Goldman, IT Manager
  • Start date

J

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 ...
 
Ad

Advertisements

J

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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top