EA crashing when connecting to Heroku Postgres Rep

[mogarick1]

I've lost almost all my day trying to make EA to work connecting to a model repository on Heroku.

I've succesfully got a new Model transfered to Heroku Postgres via Data Management option inside EA but when trying to open de model by using the connect to server option EA crashes trying to connect. It doesn't tigger any windows error screen. It just closes.

The crash occurs after the last step, when I've given a name for the Model, selecting Lazy Loading, etc. I tried ticking and unticking the WAN Optimizer option (I've also installed Wan optimizer) but got same result.
I tried using different ODBC versions of the Postgres Driver but got the same result.

My config specs are:

EA: 9.0.905
Postgres ODBC:  9.01.02.00 Unicode (tried 9.01.01 and 8.04.02 also)
OS: Win XP SP3
ODBC Connection String (With the user, server and pass obviously not indicated here):

DSN=<My Model Name>;
DATABASE=<My Postgres Heroku DB URL>
PORT=5432;
UID=<My username> ;
PWD=<my password>;
SSLmode=require;
ReadOnly=0;
Protocol=7.4-1;
FakeOidIndex=0;
ShowOidColumn=0;
RowVersioning=0;
ShowSystemTables=0;
ConnSettings=;
Fetch=100;
Socket=4096;
UnknownSizes=0;
MaxVarcharSize=1024;
MaxLongVarcharSize=1000000;
Debug=0;
CommLog=0;
Optimizer=0;
Ksqo=1;
UseDeclareFetch=1;
TextAsLongVarchar=1;
UnknownsAsLongVarchar=1;
BoolsAsChar=0;
Parse=0;
CancelAsFreeStmt=0;
ExtraSysTablePrefixes=dd_;
LFConversion=1;
UpdatableCursors=1;
DisallowPremature=1;
TrueIsMinus1=0;
BI=0;
ByteaAsLongVarBinary=1;
UseServerSidePrepare=0;
LowerCaseIdentifier=0;
GssAuthUseGSS=0;
XaOpt=1

Any idea what can be the reason of such weird behavior?

Thank you in advance for the help.

[Bohusz]

I had similar problem. I was trying to connect to locally installed Postgres 9.2 on Windows 7 64-bit. I created a 32-bit ODBC datasource, configured it according to the documentation and tested. Then in EA I say Connecto to Server, select the DS, test it, set EA name for it and then, after a while, EA said:

Database Connection Error
Reopening connection to database.
[Quit]

then it said

Enterprise Architect has experienced a network error and will close down.
[OK]

And it did so.

I've found, tat although I created the model databse as owned by user ea_amis, this use cannot do anything with the databse. After granting it all rights on all objects

GRANT ALL ON ALL TABLES IN SCHEMA public TO ea_amis;
GRANT ALL ON ALL SEQUENCES IN SCHEMA public TO ea_amis;

the EA succesfully connected to the database. (The second GRANT is not required for connecting, but necessary afterwards.)