EA 13 Beta - cannot open project in Server Based Repository (PostgreSQL)

[Romanus]

The PostgreSQL ODBC Data Source has been set as described in http://www.sparxsystems.com/enterprise_architect_user_guide/13.0/model_repository/setupapostgresqlodbcdriver.html.
Connection test in ODBC Data Source Administrator has been successful.
In Enterprise Architect Beta (13.0.1303) cannot open project in PostgreSQL data repository.
A message is displayed: "The selected ODBC DSN 'xxx' can not be found or is invalid."

In the Enterprise Architect 12.1.1230 project opens without problems (with the same Connection String).

Can anyone help me solve this problem?

[qwerty]

I guess Sparx would like to know about this bug. It's a beta...

q.

[ea0916]

Is there a fix for this yet, having exactly the same issue with the latest build of EA 13 (13.0.1306).

Works fine on EA 12.1.

[qwerty]

Maybe the OP did not send a bug report for some reason. You should (this page bottom right).

q.

[ChrisMW]

I have noticed this in some situations in EA 13.5 as well, most notably running under Wine, and on a Win7 32bit machine. I cannot replicate it under W7/64 though, which is essentially the same configuration.

However, where it does not work, I have found that defining the database as a User DSN solves the problem, it only appears for me when I define the source as a system DSN. Perhaps that helps you....

[ea0916]

Thanks ChrisMW that worked!  So System DSN doesn't work?

[Eve]

Regarding the System DSN not working, could you please run EA on the command line, redirecting the output to a file.

wine EA.exe > debuglog.txt

Run to after trying to connect and then send us the resulting file.

I'm told that should give us all the information we need to debug the problem.

[ea0916]

Hi Simon,

We're not using Wine, purely just Windows 7 though the same error surfaced by the looks of it.

[ChrisMW]

It happens to me under Wine and one Windows 7 box (running under VirtualBox). I can take a stab at running it and capturing things, but the UI responds both equally under wine or win7/32, however for some weird reason it does not happen on my win7/64 machine. In all cases, when you define the DSN, the ODBC setup works perfectly, test connection returns successfully. When you access that DSN under EA, it throws a 'invalid DSN or not found' error. It is as if EA can't find the system DSN. So far, defining as an User DSN solves the immediate problem.

I tried to create a log as you suggested, first attempt was opening the DSN defined as a system DSN. I closed the program after getting the error. Then I repeated the test with the same database defined as an user DSN and closed the program after it opened the repository successfully. In both cases the file was empty (0 bytes).