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
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 |