UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE 'UCS-2LE'

From: Joao Augusto Lima Ferreira <joaof(at)pbh(dot)gov(dot)br>
To: pgsql-odbc(at)postgresql(dot)org
Subject: UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE 'UCS-2LE'
Date: 2018-09-05 20:01:16
Message-ID: CAB7ucJJhew0r72bHuysy3yyLbRuBHBkc88+dG2gST3wU9_s_qA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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
Description = Banco de dados BHIP
Database = xxx_xxx
Servername = xxx.xxx.xxx.xx
Port = 5432
DriverUnicodeType = 1

*follows the Isql execution:*

[pcenter(at)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(at)pbh(dot)gov(dot)br / (31) 3277-7114

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Inoue, Hiroshi 2018-09-07 00:22:19 Re: UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE 'UCS-2LE'
Previous Message Kumar, Virendra 2018-09-04 14:18:00 RE: psqlODBC