Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Error Received when using Access 2007 to connect to Oracle

Posted on 2014-03-28
3
337 Views
Last Modified: 2014-05-02
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).

UserDSN
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?

LinkedTableError
0
Comment
Question by:jmcclosk
  • 2
3 Comments
 
LVL 16

Accepted Solution

by:
Walter Ritzel earned 500 total points
ID: 39962151
This is a very difficult error to deal with, so I think you'll need to contact your corporate side.
One reference I found on the internet is this:
http://agstamy.blogspot.com.br/2011/03/ora-00600-internal-error-code-arguments.html
0
 
LVL 16

Expert Comment

by:Walter Ritzel
ID: 39962164
Another link:
stackoverflow.com/questions/511534/oracle-ora-00600

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

Author Comment

by:jmcclosk
ID: 39962174
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!
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question