Postgres Pro
Downloads
Home   >   mailing lists

Re: UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE 'UCS-2LE' - Mailing list pgsql-odbc

From Inoue, Hiroshi
Subject Re: UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE 'UCS-2LE'
Date
Msg-id f57c4d56-7c0c-d28e-3cfc-690c4c198282@dream.email.ne.jp
Whole thread Raw
In response to UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE 'UCS-2LE'  (Joao Augusto Lima Ferreira <joaof@pbh.gov.br>)
Responses Re: UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE 'UCS-2LE'
List pgsql-odbc
Tree view
Hi Joao,

On 2018/09/06 5:01, Joao Augusto Lima Ferreira wrote:
Dear, 

First of all, thank you for your attention.

I have the following packages installed in my Linux OS Centos 3.10.0-514.el7.x86_64:

postgresql-libs-9.2.23-3.el7_4.x86_64
postgresql-odbc-09.03.0100-2.el7.x86_6

I already have a PostgreSQL ODBC connection configured and functional, but when trying to create the new connection below and use the Isql utility to perform a test I am getting the error below, I did not find much about it, would you like to know how to proceed in this case?

follows the odbc.ini conf:

[BHIP_PGSQL]
Driver=/usr/lib64/psqlodbcw.so

What is the output of "ldd -r path_to_isql" and
the output of "ldd -r /usr/lib64/psqlodbcw.so"?

regards,
Hiroshi Inoue

Description =  Banco de dados BHIP
Database = xxx_xxx
Servername = xxx.xxx.xxx.xx
Port = 5432
DriverUnicodeType = 1

follows the Isql execution:

[pcenter@pcenterdev ~]$ isql -v BHIP_PGSQL user ****************
[28000][unixODBC]Communication closed during authentication;
Connection reset by peer.
[ISQL]ERROR: Could not SQLConnect

follows the execution trace:

[ODBC][6121][1536176591.163931][__handles.c][460]
                Exit:[SQL_SUCCESS]
                        Environment = 0x1e11780
[ODBC][6121][1536176591.164096][SQLAllocHandle.c][375]
                Entry:
                        Handle Type = 2
                        Input Handle = 0x1e11780
[ODBC][6121][1536176591.164158][SQLAllocHandle.c][493]
                Exit:[SQL_SUCCESS]
                        Output Handle = 0x1e12080
[ODBC][6121][1536176591.164220][SQLConnect.c][3700]
                Entry:
                        Connection = 0x1e12080
                        Server Name = [BHIP_PGSQL][length = 10 (SQL_NTS)]
                        User Name = [user][length = 4 (SQL_NTS)]
                        Authentication = [****************][length = 16 (SQL_NTS)]
                UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE 'UCS-2LE'
 
                DIAG [28000] Communication closed during authentication;
Connection reset by peer.
 
[ODBC][6121][1536176591.321348][SQLConnect.c][4067]
                Exit:[SQL_ERROR]
[ODBC][6121][1536176591.321419][SQLError.c][434]
                Entry:
                        Connection = 0x1e12080
                        SQLState = 0x7ffc89f63280
                        Native = 0x7ffc89f6327c
                        Message Text = 0x7ffc89f63290
                        Buffer Length = 500
                        Text Len Ptr = 0x7ffc89f6327a
[ODBC][6121][1536176591.321471][SQLError.c][471]
                Exit:[SQL_SUCCESS]
                        SQLState = 28000
                        Native = 0x7ffc89f6327c -> 210
                        Message Text = [[unixODBC]Communication closed during authentication;
Connection reset by peer.]
[ODBC][6121][1536176591.321549][SQLError.c][434]
                Entry:
                        Connection = 0x1e12080
                        SQLState = 0x7ffc89f63280
                        Native = 0x7ffc89f6327c
                        Message Text = 0x7ffc89f63290
                        Buffer Length = 500
                        Text Len Ptr = 0x7ffc89f6327a
[ODBC][6121][1536176591.321588][SQLError.c][471]
                Exit:[SQL_NO_DATA]
[ODBC][6121][1536176591.321629][SQLError.c][514]
                Entry:
                        Environment = 0x1e11780
                        SQLState = 0x7ffc89f63280
                        Native = 0x7ffc89f6327c
                        Message Text = 0x7ffc89f63290
                        Buffer Length = 500
                        Text Len Ptr = 0x7ffc89f6327a
[ODBC][6121][1536176591.321669][SQLError.c][551]
                Exit:[SQL_NO_DATA]
[ODBC][6121][1536176591.321738][SQLFreeHandle.c][284]
                Entry:
                        Handle Type = 2
                        Input Handle = 0x1e12080
[ODBC][6121][1536176591.321782][SQLFreeHandle.c][333]
                Exit:[SQL_SUCCESS]
[ODBC][6121][1536176591.321824][SQLFreeHandle.c][219]
                Entry:
                        Handle Type = 1
                        Input Handle = 0x1e11780




system.out.println("Atenciosamente");

--

João Ferreira - Gerência de Engenharia e Processo de Software - GPAS-PB - Prodabel

PRODABEL | Av. Presidente Carlos Luz,1275

joaof@pbh.gov.br / (31) 3277-7114








ウイルス フリー｡ www.avg.com

pgsql-odbc by date:

Previous
From: Joao Augusto Lima Ferreira
Date:
Subject: UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE 'UCS-2LE'
Next
From: Igor Korot
Date:
Subject: PostgreSQL on OSX