DB Connect - system not accessible in QA
We created a DB Connect source system in our BI Dev environment, and successfully extracted data there.
However, when we try the same connection in our QA environment, we get an error that the system cannot be connected to.
Our BI (7.0) is on Oracle 11, and our source is on an MS SQL server (2000).
The database system XXXX is not accessible.
The system tried but failed to establish a database link. A short dump has been registered.
This connection was used successfully in the past (several months ago), but now the connection no longer works. We have checked the connection parameters, and there are no entries in the error log for the source system. We have successfully done some loads into BI Dev, so we know the systems can still communicate. We also just did a restart of our BI QA system.
Any hints, suggestions, or solutions would be most welcome!!