From: | Jose Raul Da Conceicao <Joseraul(dot)DaConceicao(at)amdocs(dot)com> |
---|---|
To: | "Ebadi, Abdul" <abdul(dot)ebadi(at)centurylink(dot)com>, "Abhinav, Kumar" <Kumar(dot)Abhinav(at)centurylink(dot)com>, "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>, "Hass, Sandy" <Sandy(dot)Hass(at)CenturyLink(dot)com>, "Perambur Subramanian, Saravanan" <saravanan(dot)perambursubramanian(at)centurylink(dot)com> |
Cc: | Santiago Simosis <Santiago(dot)Simosis(at)amdocs(dot)com>, Nicholas Vidamour <Nicholas(dot)Vidamour(at)amdocs(dot)com>, Andriy Gupalenko <Andriy(dot)Gupalenko(at)amdocs(dot)com>, "Iyer, Sangeetha" <sangeetha(dot)iyer(at)centurylink(dot)com> |
Subject: | RE: Postgresql-ODBC |
Date: | 2020-04-09 13:17:54 |
Message-ID: | AM6PR06MB451993EB17CE849908224EF9F0C10@AM6PR06MB4519.eurprd06.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Hi Abdul, good day,
Please see below the feedback from our DBA
You can just install on host with Oracle database:
$ yum install postgresql-odbc
$ yum list installed|grep -i odbc
postgresql-odbc.x86_64 09.03.0100-2.el7 @RHEL-7.5-x86_64
unixODBC.x86_64 2.3.1-11.el7 @RHEL-7.5-x86_64
It should automatically configure the psqlODBC driver libraries in ODBC Driver file odbcinst.ini.
Like:
# more /etc/odbcinst.ini
# Example driver definitions
# Driver from the postgresql-odbc package
# Setup from the unixODBC package
[PostgreSQL]
Description = ODBC for PostgreSQL
Driver = /usr/lib/psqlodbcw.so
Setup = /usr/lib/libodbcpsqlS.so
Driver64 = /usr/lib64/psqlodbcw.so
Setup64 = /usr/lib64/libodbcpsqlS.so
FileUsage = 1
And go on with a Data Source Name (DSN) configuration in the odbc.ini
Please let us know if this works on your end and if you have any additional questions.
Regards,
Jose Raul Da Conceiçao
Amdocs Optima
+56-977018407 (Mobile + IM)
[amdocs-2017-brand-mark-rgb]
From: Ebadi, Abdul <abdul(dot)ebadi(at)centurylink(dot)com>
Sent: Tuesday, April 7, 2020 5:28 PM
To: Abhinav, Kumar <Kumar(dot)Abhinav(at)centurylink(dot)com>; pgsql-odbc(at)postgresql(dot)org; Jose Raul Da Conceicao <Joseraul(dot)DaConceicao(at)amdocs(dot)com>; Santiago Simosis <Santiago(dot)Simosis(at)amdocs(dot)com>; Iyer, Sangeetha <sangeetha(dot)iyer(at)centurylink(dot)com>; Hass, Sandy <Sandy(dot)Hass(at)CenturyLink(dot)com>; Perambur Subramanian, Saravanan <saravanan(dot)perambursubramanian(at)centurylink(dot)com>
Subject: RE: Postgresql-ODBC
Forgot to include Saravanan earlier...
From: Ebadi, Abdul
Sent: Tuesday, April 7, 2020 12:06 PM
To: Abhinav, Kumar <Kumar(dot)Abhinav(at)centurylink(dot)com<mailto:Kumar(dot)Abhinav(at)centurylink(dot)com>>; pgsql-odbc(at)postgresql(dot)org<mailto:pgsql-odbc(at)postgresql(dot)org>; Joseraul(dot)DaConceicao(at)amdocs(dot)com<mailto:Joseraul(dot)DaConceicao(at)amdocs(dot)com>; Santiago Simosis <Santiago(dot)Simosis(at)amdocs(dot)com<mailto:Santiago(dot)Simosis(at)amdocs(dot)com>>; Iyer, Sangeetha <sangeetha(dot)iyer(at)centurylink(dot)com<mailto:sangeetha(dot)iyer(at)centurylink(dot)com>>; Hass, Sandy <Sandy(dot)Hass(at)CenturyLink(dot)com<mailto:Sandy(dot)Hass(at)CenturyLink(dot)com>>
Subject: RE: Postgresql-ODBC
Adding Jose and Santiago to see if we can get some help on this issue from Amdocs (trying to create db link from oracle to postgres). See details of odbc version issue below...
FYI Kumar is our offshore CTL Postgres DBA.
Thanks,
Abdul
From: Abhinav, Kumar <Kumar(dot)Abhinav(at)centurylink(dot)com<mailto:Kumar(dot)Abhinav(at)centurylink(dot)com>>
Sent: Monday, March 30, 2020 4:06 AM
To: pgsql-odbc(at)postgresql(dot)org<mailto:pgsql-odbc(at)postgresql(dot)org>
Cc: Ebadi, Abdul <abdul(dot)ebadi(at)centurylink(dot)com<mailto:abdul(dot)ebadi(at)centurylink(dot)com>>; Hass, Sandy <Sandy(dot)Hass(at)CenturyLink(dot)com<mailto:Sandy(dot)Hass(at)CenturyLink(dot)com>>
Subject: Postgresql-ODBC
Hi Team,
Our PostgreSQL server is on Azure and the version is 11.5 on linux . We want to create a db link from oracle server . We have a question .
1. Which version of ODBC driver we have to install . Do PostgreSQL has 11.5 ODBC ? Can we use the ODBC version 9 for our 11.5 version PostgreSQL . Will it work?
Warm Regards
Kumar Abhinav
DBA
918147858803.
This communication is the property of CenturyLink and may contain confidential or privileged information. Unauthorized use of this communication is strictly prohibited and may be unlawful. If you have received this communication in error, please immediately notify the sender by reply e-mail and destroy all copies of the communication and any attachments.
This email and the information contained herein is proprietary and confidential and subject to the Amdocs Email Terms of Service, which you may review at https://www.amdocs.com/about/email-terms-of-service <https://www.amdocs.com/about/email-terms-of-service>
From | Date | Subject | |
---|---|---|---|
Next Message | Artashes Khachatryan Galust | 2020-04-29 13:42:29 | |
Previous Message | Ebadi, Abdul | 2020-04-07 21:28:04 | RE: Postgresql-ODBC |