jmcclosk
asked on
Error Received when using Access 2007 to connect to Oracle
I work for a large company that has several Oracle databases. Over the past several weeks, I was able to get a successful connection to one of these Oracle DBs by setting up a User DSN data source with the credentials corporate IT provided me with, and was able to successfully link to the tables in Oracle using Microsoft Access 2007 ODBC Database, Link to Data Source.
I am now trying to connect to a second, separate Oracle database. I was, once again, able to set this up as a successful User DSN Data Source and I get a successful test connection (see image below).
However, when I go to Access and try to link to this new DBs tables, I get the error below. I've linked to many types of databases using Access (AS/400, SQL, Oracle, etc.) and have never seen a situation where I have a successful connection in ODBC Driver Configuration but errors from within the Access application. Usually, if one works, so does the other and if one does not work then neither does the other.
I have no accessibility to the Oracle side of this. I am just trying to determine, and hopefully rule out, an Access or local PC issue before I go back to the corporate people. Can anyone shed light on what this error means? And, is there anything further I can try to resolve this before I have to get more people involved?
I am now trying to connect to a second, separate Oracle database. I was, once again, able to set this up as a successful User DSN Data Source and I get a successful test connection (see image below).
However, when I go to Access and try to link to this new DBs tables, I get the error below. I've linked to many types of databases using Access (AS/400, SQL, Oracle, etc.) and have never seen a situation where I have a successful connection in ODBC Driver Configuration but errors from within the Access application. Usually, if one works, so does the other and if one does not work then neither does the other.
I have no accessibility to the Oracle side of this. I am just trying to determine, and hopefully rule out, an Access or local PC issue before I go back to the corporate people. Can anyone shed light on what this error means? And, is there anything further I can try to resolve this before I have to get more people involved?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Yes, it would have to all be done on the oracle side as I cannot even make a link with any of the tables. So, I would not be able to base any queries off of them. After I click "OK" to the error listed above, it brings up a completely blank table window and gives me no tables to select from or link to.
I will pass this information on to my corporate contacts. Thanks!
I will pass this information on to my corporate contacts. Thanks!
stackoverflow.com/question
This is interesting, as the answer marked also suggest that change a query a little bit or fiddling with the index make the problem disappears.
Maybe you can ask people on the oracle side to rebuild indexes from the tables involved, just to make sure.