Author Topic: Postgres Sparx Cannot see Entreprise Architect tables  (Read 1030 times)

slurton

  • EA Novice
  • *
  • Posts: 5
  • Karma: +0/-0
    • View Profile
Postgres Sparx Cannot see Entreprise Architect tables
« 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.

Prostomax

  • EA Novice
  • *
  • Posts: 8
  • Karma: +0/-0
  • I love YaBB 1G - SP1!
    • View Profile
Re: Postgres Sparx Cannot see Entreprise Architect tables
« Reply #1 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!'


slurton

  • EA Novice
  • *
  • Posts: 5
  • Karma: +0/-0
    • View Profile
Re: Postgres Sparx Cannot see Entreprise Architect tables
« Reply #2 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.

Prostomax

  • EA Novice
  • *
  • Posts: 8
  • Karma: +0/-0
  • I love YaBB 1G - SP1!
    • View Profile
Re: Postgres Sparx Cannot see Entreprise Architect tables
« Reply #3 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.