Cannot connect to Oracle respository

[Richard Phillips]

A new Oracle repository was set up by our DBA recently, I have been able to connect and upgrade our models successfully. However, only some of our users can successfully connect to the repository. The most common problem, is that a password dialog appears, none of the known passwords work at this point (e.g. database pwd, user pwd etc).

Can anyone give me any pointers on what to look for to diagnose this problem.

[Geert Bellekens]

First thing to look at is the database driver that is used to connect to Oracle.
EA is pretty particular in which driver is used. Use a wrong driver, or even the wrong version, and it won't work.

Geert

[Richard Phillips]

Thanks for the swift reply.

The connect string is...

enterprise_arc --- DBType=3;Connect=Provider=OraOLEDB.Oracle.1;Password=*******;Persist Security Info=True;User ID=ENTERPRISE_ARC;Data Source=MISC

from which I assume the driver is the Oracle driver (not the microsoft ODBC for oracle) SQORA32.DLL.

Is this the driver that you are referring to. I have 9.02.00.00 and presumably, I need to check that this version is consistent across all machines that are accessing the EA repository.

Thanks.

[Geert Bellekens]

I don't know which version of the driver you need.
I've installed EA on an Oracle backend a few years ago at another client, I just remember that the version of the driver was an issue.
I think there are some documents on the EA site as well that have details regarding that stuff.

Geert