Failure on connection to Oracle Repository

[lizobri]

We have a repository on Oracle and we connect with the OLE DB Provider for Oracle. One of our users receives the following error message when he attemps to connect: "Provider - 2147418113 Catastrophic Failure".

We have recreated his connection in EA, restarted his computer but he gets the same problem. Others users are fine and can connect.

Any idea? Thanks!

[philchudley]

When connecting to Oracle it is [highlight]ESSENTIAL to use the Oracle ODBC driver (the one installed with Oracle client), and definitely NOT the one provided by Microsoft.
[/highlight]
The driver listed in your post is the Microsoft Oracle ODBC driver and doomed to failure

Get the user to connect using the Oracle provided ODBC and all should be fine

[lizobri]

Thank you for your reply! I have double checked and we are using the Oracle Provider for OLE DB. All the repository users are using this provider but I have only one user whose connexion fails.

My next step will be to remove and reinstall the Oracle client on the user workstation and check he can connect to the repository.