Postgresql driver ODBC for linux

From: Ronald Cabral <ronald(dot)t(dot)cabral(at)gmail(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Postgresql driver ODBC for linux
Date: 2023-06-12 13:14:41
Message-ID: CAAuBg4Tc=7JGz0Aivfx7Kr_+TSnV6bDGOvy36v2QNOUBTxf0zA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi,

I am setting up Heterogenous services to connect Oracle to Postgresql.
how can i check if my postgres ODBC driver can support Unicode.
the connection is failing if HS_LANGUAGE is UTF8 but OK
using AMERICAN_AMERICA.WE8ISO8859P9

-bash-4.2$ rpm -qa | grep -i odbc
unixODBC-2.3.1-14.0.1.el7.x86_64
postgresql-odbc-09.03.0100-2.el7.x86_64

-bash-4.2$ more /home/oracle/.odbc.ini
[ODBC Data Sources]
PG = PostgreSQL

[PG]
Description = Postgres
Driver = PostgreSQL
ServerName = glsdvlpgdb132
Username = wmscoe_dashboard
Password = n4SX2ey9qWRa
Port = 5432
Database=gpwcd01d
ConnSettings=SET CLIENT_ENCODING TO 'UTF8'
[Default]
Driver = /usr/lib64/liboplodbcS.so.2

-bash-4.2$ 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

# Driver from the mysql-connector-odbc package
# Setup from the unixODBC package
[MySQL]
Description = ODBC for MySQL
Driver = /usr/lib/libmyodbc5.so
Setup = /usr/lib/libodbcmyS.so
Driver64 = /usr/lib64/libmyodbc5.so
Setup64 = /usr/lib64/libodbcmyS.so
FileUsage = 1

Browse pgsql-odbc by date

  From Date Subject
Next Message Miloslav Zadrazil 2023-06-14 10:00:20 psqlODBC drivers 13.2 flagged to be vulnerable for openssl 1.1.1l vulnerabilities
Previous Message Niezel, Benjamin (LDBV) 2023-06-05 08:46:22 PostgreSQL ODBC driver for PostgreSQL Version 15?