Sparx Systems Forum

Enterprise Architect => Bugs and Issues => Topic started by: Richard Phillips on January 27, 2010, 10:41:57 pm

Title: Cannot connect to Oracle respository
Post by: Richard Phillips on January 27, 2010, 10:41:57 pm

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.

Title: Re: Cannot connect to Oracle respository
Post by: Geert Bellekens on January 27, 2010, 10:49:47 pm

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

Title: Re: Cannot connect to Oracle respository
Post by: Richard Phillips on January 27, 2010, 11:12:18 pm

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.

Title: Re: Cannot connect to Oracle respository
Post by: Geert Bellekens on January 27, 2010, 11:40:40 pm

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