Sparx Systems Forum

Enterprise Architect => Bugs and Issues => Topic started by: slurton on January 07, 2020, 03:21:42 am

Title: Postgres Sparx Cannot see Entreprise Architect tables
Post by: slurton on January 07, 2020, 03:21:42 am
I put a Postgres database on my local machine and was able to create and and connect to a Enterprise Architect Repository.
However, when I setup Postgres on another server on the network then Sparx does not see the repository tables.
If I connect to it using Microsoft Excel it sees all of the tables with not problem but not with Sparx.

Any Ideas, this is probably a permissions problem.
Title: Re: Postgres Sparx Cannot see Entreprise Architect tables
Post by: Prostomax on January 28, 2020, 02:17:48 am
I have the similar issue with PostgreSQL 12.
Latest ODBC are installed for x86 version.

EA 15.1 can connect but says 'Error retrieving table list!'

Title: Re: Postgres Sparx Cannot see Entreprise Architect tables
Post by: slurton on January 28, 2020, 02:26:09 am
I figured it out. In Postgres you have to define a default path for your login.
I'm coming from Oracle and you don't have to do this.
I you want the details of what I did reply to this post and I'll give them to you.
Title: Re: Postgres Sparx Cannot see Entreprise Architect tables
Post by: Prostomax on January 28, 2020, 09:18:35 pm
Started another thread on RG 12 with more details, since your solution does not apply to my case.