public inbox for [email protected]
help / color / mirror / Atom feedFrom: Matt Russo (mrusso) <[email protected]>
To: [email protected] <[email protected]>
Subject: FW: PostgreSQL ODBC driver will not connect Thanks.
Date: Thu, 22 Jul 2021 15:28:28 +0000
Message-ID: <BLAPR19MB454818284E4A1E527D08C16499E49@BLAPR19MB4548.namprd19.prod.outlook.com> (raw)
In-Reply-To: <BLAPR19MB4548A33D53BD302500258EBC99E49@BLAPR19MB4548.namprd19.prod.outlook.com>
References: <BLAPR19MB4548A33D53BD302500258EBC99E49@BLAPR19MB4548.namprd19.prod.outlook.com>
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: [email protected]<mailto:[email protected]> erwin by Quest
From: Matt Russo (mrusso)
Sent: Wednesday, July 21, 2021 11:49 AM
To: Anil Kumar Rajulapati (arajulap) <[email protected]<mailto:[email protected]>>; Prajval Poojari (ppoojari) <[email protected]<mailto:[email protected]>>; Bob Sethi (bsethi) <[email protected]<mailto:[email protected]>>; Margaret Ma (mma) <[email protected]<mailto:[email protected]>>; Vaishali Bhalerao (vbhalera) <[email protected]<mailto:[email protected]>>
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:[email protected]]
From: Anil Kumar Rajulapati (arajulap) <[email protected]<mailto:[email protected]>>
Sent: Tuesday, July 20, 2021 3:32 AM
To: Prajval Poojari (ppoojari) <[email protected]<mailto:[email protected]>>; Matt Russo (mrusso) <[email protected]<mailto:[email protected]>>; Bob Sethi (bsethi) <[email protected]<mailto:[email protected]>>; Margaret Ma (mma) <[email protected]<mailto:[email protected]>>; Vaishali Bhalerao (vbhalera) <[email protected]<mailto:[email protected]>>
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/...;
Anil Kumar Rajulapati | Principal Software Engineer
P: +91 9885253329 E: [email protected]<mailto:[email protected]> W: erwin.com<https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Ferwin.com%2F&data=04%7C01%7CMa...;
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&...;
Serilingampally Mandal, R. R. District, Hyderabad, Telangana - 500032<https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgoo.gl%2Fmaps%2FkaSrkBn979jn6vb28&...; | O: 040 67454111
[cid:[email protected]]
P Please consider the environment before printing this e-mail.
From: Prajval Poojari (ppoojari) <[email protected]<mailto:[email protected]>>
Sent: 20 July 2021 08:10
To: Matt Russo (mrusso) <[email protected]<mailto:[email protected]>>; Anil Kumar Rajulapati (arajulap) <[email protected]<mailto:[email protected]>>; Bob Sethi (bsethi) <[email protected]<mailto:[email protected]>>; Margaret Ma (mma) <[email protected]<mailto:[email protected]>>; Vaishali Bhalerao (vbhalera) <[email protected]<mailto:[email protected]>>
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%7...;
________________________________
From: Matt Russo (mrusso) <[email protected]<mailto:[email protected]>>
Sent: Tuesday, July 20, 2021 2:17:14 AM
To: Anil Kumar Rajulapati (arajulap) <[email protected]<mailto:[email protected]>>; Bob Sethi (bsethi) <[email protected]<mailto:[email protected]>>; Margaret Ma (mma) <[email protected]<mailto:[email protected]>>; Prajval Poojari (ppoojari) <[email protected]<mailto:[email protected]>>; Vaishali Bhalerao (vbhalera) <[email protected]<mailto:[email protected]>>
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:[email protected]]
Matt Russo | Enterprise Technical Support Senior Advanced
P: 813-600-3438 E: [email protected]<mailto:[email protected]> erwin by Quest
Attachments:
[image/jpeg] image001.jpg (168.8K, ../BLAPR19MB454818284E4A1E527D08C16499E49@BLAPR19MB4548.namprd19.prod.outlook.com/3-image001.jpg)
download | view image
[image/jpeg] image002.jpg (3.6K, ../BLAPR19MB454818284E4A1E527D08C16499E49@BLAPR19MB4548.namprd19.prod.outlook.com/4-image002.jpg)
download | view image
[image/jpeg] image003.jpg (168.6K, ../BLAPR19MB454818284E4A1E527D08C16499E49@BLAPR19MB4548.namprd19.prod.outlook.com/5-image003.jpg)
download | view image
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected]
Subject: Re: FW: PostgreSQL ODBC driver will not connect Thanks.
In-Reply-To: <BLAPR19MB454818284E4A1E527D08C16499E49@BLAPR19MB4548.namprd19.prod.outlook.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox