Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: Boron on November 03, 2015, 06:08:22 pm

Title: EA and PostgreSQL x64
Post by: Boron on November 03, 2015, 06:08:22 pm

Hello,
I am currently "evaluating" if we can use EA (currently 12.0) with PostgreSQL 9.4 x64 as central repository server.

We are currently using EA with PostgreSQL 9.3 32 bit which work pretty fine.
On the clients we use psqlodbc 09.03 32 bit as ODBC driver.
EA clients run on Win 7 64 bit and PostgreSQL server runs on Windows 2012 R2.

When trying to connect to PostgreSQL 9.4 64 bit I face several issues:

• Using psqlodbc 09.03 32 bit: EA 12 tries to open the database (all tables exist, but model is still empty):
• EA tells the model is empty and ask to transfer a model into the database
• When clicking "Yes" the next window that appears tells "EA has experienced a network error and will close down." :(
• Using psqlodbc 09.03 64 bit:
• EA does not even provide the database connection I configured for the test database :(

Does anybody have experience with EA and 64 bit PostgreSQL servers?
I would even appreciate an answer like "Hey dude, forget EA and PostgreSQL x64. This does not work. Use x86 and be happy."

Title: Re: EA and PostgreSQL x64
Post by: Boron on December 05, 2019, 10:23:04 pm

Hello,

are there any news on the usage of 64 bit database management systems, e.g. PostgreSQL x64?

This page does not provide any information on this: https://sparxsystems.com/enterprise_architect_user_guide/15.0/model_repository/settingupdatabasemodelfile.html

Background:
We would like to update from PostgreSQL 9.5 to (preferably) the latest version 12.1.
But beginning with PostgreSQL 11 no more 32 bit version are offered: https://www.enterprisedb.com/downloads/postgres-postgresql-downloads

Title: Re: EA and PostgreSQL x64
Post by: Eve on December 06, 2019, 09:20:11 am

Do they still have a 32 bit driver to connect to the 64 bit database? If so, that's your answer.

Title: Re: EA and PostgreSQL x64
Post by: Boron on December 06, 2019, 08:26:20 pm

Thanks Eve, good hint.

Up to now I had the psqlODBC database driver installed in a x86 version (downloaded file name was psqlodbc_11_00_0000-x86.zip).
Now I replaced that with psqlodbc_11_00_0000.zip (no postfix like x86 or x64). This seems to combine x86 und x64 driver versions (yes, I am aware that there is already a version 12 of the driver).

And *tadaaa* I can open my models on the "PostgreSQL 12 x64 server".