FW: PostgreSQL ODBC driver will not connect Thanks.

Hi,

I went to the Communities site but could not figure out how to post my question. I'm having the below problem connecting PostgreSQL ODBC to my database. Could you please assist me?

Thanks in advance,

Matt

Matt Russo | Enterprise Technical Support Senior Advanced
P: 813-600-3438 E: Matt(dot)Russo(at)Quest(dot)com<mailto:Matt(dot)Russo(at)Quest(dot)com> erwin by Quest

From: Matt Russo (mrusso)
Sent: Wednesday, July 21, 2021 11:49 AM
To: Anil Kumar Rajulapati (arajulap) <Anil(dot)Kumar(dot)Rajulapati(at)quest(dot)com<mailto:Anil(dot)Kumar(dot)Rajulapati(at)quest(dot)com>>; Prajval Poojari (ppoojari) <Prajval(dot)Poojari(at)quest(dot)com<mailto:Prajval(dot)Poojari(at)quest(dot)com>>; Bob Sethi (bsethi) <Bob(dot)Sethi(at)quest(dot)com<mailto:Bob(dot)Sethi(at)quest(dot)com>>; Margaret Ma (mma) <Margaret(dot)Ma(at)quest(dot)com<mailto:Margaret(dot)Ma(at)quest(dot)com>>; Vaishali Bhalerao (vbhalera) <Vaishali(dot)Bhalerao(at)quest(dot)com<mailto:Vaishali(dot)Bhalerao(at)quest(dot)com>>
Subject: RE: PostgreSQL driver will not connect SR Number:4924653| for ACCENTRURE FEDERAL SERVICES Thanks.

I installed the PostgreSQL 13 ODBC drivers (thanks Maggie). This is working for Maggie.

I fully uninstalled PostgreSQL. Deleted the directory postgresql in program files.'
Fully uninstalled the ODBC drivers.
I installed PostgreSQL 13.
I installed the 13 ODBC drivers.
I am still getting the same error.
No bugs listed like this on https://www.postgresql.org/list/pgsql-bugs/
Dr. Google suggests a role or username is lacking. So I try adding a role but it says user postgres already exists.
I tried adding a second user. No good trying the second user.
I can connect to the db in postgresql.

Does anyone have any other advice?

Thanks,

Matt

[cid:image001(dot)jpg(at)01D77EEC(dot)B12D32F0]

From: Anil Kumar Rajulapati (arajulap) <Anil(dot)Kumar(dot)Rajulapati(at)quest(dot)com<mailto:Anil(dot)Kumar(dot)Rajulapati(at)quest(dot)com>>
Sent: Tuesday, July 20, 2021 3:32 AM
To: Prajval Poojari (ppoojari) <Prajval(dot)Poojari(at)quest(dot)com<mailto:Prajval(dot)Poojari(at)quest(dot)com>>; Matt Russo (mrusso) <Matt(dot)Russo(at)quest(dot)com<mailto:Matt(dot)Russo(at)quest(dot)com>>; Bob Sethi (bsethi) <Bob(dot)Sethi(at)quest(dot)com<mailto:Bob(dot)Sethi(at)quest(dot)com>>; Margaret Ma (mma) <Margaret(dot)Ma(at)quest(dot)com<mailto:Margaret(dot)Ma(at)quest(dot)com>>; Vaishali Bhalerao (vbhalera) <Vaishali(dot)Bhalerao(at)quest(dot)com<mailto:Vaishali(dot)Bhalerao(at)quest(dot)com>>
Subject: RE: PostgreSQL driver will not connect SR Number:4924653| for ACCENTRURE FEDERAL SERVICES Thanks.

Hi Matt,

Use PostgreSQL ODBC Driver to work with PostgreSQL database with erwin DM.

Just for reference client ODBC can be downloaded from as per version of PostgreSQL Server: https://www.postgresql.org/ftp/odbc/versions/msi/<https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.postgresql.org%2Fftp%2Fodbc%2Fversions%2Fmsi%2F&data=04%7C01%7CMatt.Russo%40quest.com%7Cb5f6eb3b280e4360058508d94b5072e6%7C91c369b51c9e439c989c1867ec606603%7C0%7C0%7C637623631166867186%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=%2BRJCafv8%2F7u8J2Ka8cOiaTWQVLpZObqOWXBuseMeayA%3D&reserved=0>

Anil Kumar Rajulapati | Principal Software Engineer
P: +91 9885253329 E: Anil(dot)Kumar(dot)Rajulapati(at)quest(dot)com<mailto:Anil(dot)Kumar(dot)Rajulapati(at)quest(dot)com> W: erwin.com<https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Ferwin.com%2F&data=04%7C01%7CMatt.Russo%40quest.com%7Cb5f6eb3b280e4360058508d94b5072e6%7C91c369b51c9e439c989c1867ec606603%7C0%7C0%7C637623631166867186%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=YRxIXkt5c05tzUA%2FBdWvoHCdh3Pk%2FWiPjXFDuw6AIyg%3D&reserved=0>
A: erwin India Private Limited | Q City - Block B, 1st Floor, Survery No: 109,110,111/112, Nanakramguda Village, <https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgoo.gl%2Fmaps%2FkaSrkBn979jn6vb28&data=04%7C01%7CMatt.Russo%40quest.com%7Cb5f6eb3b280e4360058508d94b5072e6%7C91c369b51c9e439c989c1867ec606603%7C0%7C0%7C637623631166877141%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=LcXyBiknogxLOKn0hnCwigMLbx6cjBWrDvMCc%2FAoLoM%3D&reserved=0>
Serilingampally Mandal, R. R. District, Hyderabad, Telangana - 500032<https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgoo.gl%2Fmaps%2FkaSrkBn979jn6vb28&data=04%7C01%7CMatt.Russo%40quest.com%7Cb5f6eb3b280e4360058508d94b5072e6%7C91c369b51c9e439c989c1867ec606603%7C0%7C0%7C637623631166877141%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=LcXyBiknogxLOKn0hnCwigMLbx6cjBWrDvMCc%2FAoLoM%3D&reserved=0> | O: 040 67454111
[cid:image002(dot)jpg(at)01D77EEC(dot)B12D32F0]
P Please consider the environment before printing this e-mail.

From: Prajval Poojari (ppoojari) <Prajval(dot)Poojari(at)quest(dot)com<mailto:Prajval(dot)Poojari(at)quest(dot)com>>
Sent: 20 July 2021 08:10
To: Matt Russo (mrusso) <Matt(dot)Russo(at)quest(dot)com<mailto:Matt(dot)Russo(at)quest(dot)com>>; Anil Kumar Rajulapati (arajulap) <Anil(dot)Kumar(dot)Rajulapati(at)quest(dot)com<mailto:Anil(dot)Kumar(dot)Rajulapati(at)quest(dot)com>>; Bob Sethi (bsethi) <Bob(dot)Sethi(at)quest(dot)com<mailto:Bob(dot)Sethi(at)quest(dot)com>>; Margaret Ma (mma) <Margaret(dot)Ma(at)quest(dot)com<mailto:Margaret(dot)Ma(at)quest(dot)com>>; Vaishali Bhalerao (vbhalera) <Vaishali(dot)Bhalerao(at)quest(dot)com<mailto:Vaishali(dot)Bhalerao(at)quest(dot)com>>
Subject: Re: PostgreSQL driver will not connect SR Number:4924653| for ACCENTRURE FEDERAL SERVICES Thanks.

Hi Matt, please Postgres odbc drivers only. These drivers are not correct once's.

Get Outlook for iOS<https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Faka.ms%2Fo0ukef&data=04%7C01%7CMatt.Russo%40quest.com%7Cb5f6eb3b280e4360058508d94b5072e6%7C91c369b51c9e439c989c1867ec606603%7C0%7C0%7C637623631166887101%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=57OhsHYxjjyx95XqAxkQu%2BVj28Q%2BEB4gYS9vpVf%2Fxiw%3D&reserved=0>
________________________________
From: Matt Russo (mrusso) <Matt(dot)Russo(at)quest(dot)com<mailto:Matt(dot)Russo(at)quest(dot)com>>
Sent: Tuesday, July 20, 2021 2:17:14 AM
To: Anil Kumar Rajulapati (arajulap) <Anil(dot)Kumar(dot)Rajulapati(at)quest(dot)com<mailto:Anil(dot)Kumar(dot)Rajulapati(at)quest(dot)com>>; Bob Sethi (bsethi) <Bob(dot)Sethi(at)quest(dot)com<mailto:Bob(dot)Sethi(at)quest(dot)com>>; Margaret Ma (mma) <Margaret(dot)Ma(at)quest(dot)com<mailto:Margaret(dot)Ma(at)quest(dot)com>>; Prajval Poojari (ppoojari) <Prajval(dot)Poojari(at)quest(dot)com<mailto:Prajval(dot)Poojari(at)quest(dot)com>>; Vaishali Bhalerao (vbhalera) <Vaishali(dot)Bhalerao(at)quest(dot)com<mailto:Vaishali(dot)Bhalerao(at)quest(dot)com>>
Subject: re: PostgreSQL driver will not connect SR Number:4924653| for ACCENTRURE FEDERAL SERVICES Thanks.

Hi,

I am testing RE in erwin DM for PostgreSQL. To do that I installed the PROGRESS_DATADIRECT_ODBC_POSTGRESQL_WIN_64 ODBC drivers and when I try to configure the PostgreSQL datasource I get the below error.

I googled this but the closest I can find is there is BUG #5547: not able to connect to postgres through the oracle using Linux ODBC driver for Postgres but that seems unrelated to my situation.

I tried using both users postgres and pgasadmin but I get the same error. I am able to connect in pgadmin to the database.

Please let me know your advice to make this connect.

Thanks,

Matt

PostgreSQL 11

[cid:image003(dot)jpg(at)01D77EEC(dot)B12D32F0]

Matt Russo | Enterprise Technical Support Senior Advanced

P: 813-600-3438 E: Matt(dot)Russo(at)Quest(dot)com<mailto:Matt(dot)Russo(at)Quest(dot)com> erwin by Quest