Book a Demo

Author Topic: Unable to connect to PostgreSQL using EA  (Read 3966 times)

PhpNut

  • EA Novice
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
Unable to connect to PostgreSQL using EA
« on: November 14, 2009, 05:24:28 am »
I am trying to setup EA to use PostgreSQL as the repository. I am able to connect to database outside of EA and even inside EA clicking test connection, but after clicking ok on the last step EA throws an error:

Code: [Select]
Microsoft Cursor Engine [-214217877]
Multiple-step operation generated errors. Check each status value.

Has anyone seen this before?

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Unable to connect to PostgreSQL using EA
« Reply #1 on: November 16, 2009, 06:14:54 pm »
Are you sure it isn't a security issue?
EA needs a lot of rights to function properly.

Geert

PhpNut

  • EA Novice
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
Re: Unable to connect to PostgreSQL using EA
« Reply #2 on: November 17, 2009, 06:57:24 am »
Yes I am sure

PhpNut

  • EA Novice
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
[SOLVED] Re: Unable to connect to PostgreSQL using
« Reply #3 on: November 17, 2009, 02:24:36 pm »
Turns out the driver was the issue. Downgrading to 8.3 from 8.4 psqlodbc everything seems to be working fine.