UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE 'UCS-2LE'
Joao Augusto Lima Ferreira <[email protected]> Wed, 5 Sep 2018 17:01:16 -0300
| Newsgroups | gmane.comp.db.postgresql.odbc |
|---|---|
| Message-ID | <CAB7ucJJhew0r72bHuysy3yyLbRuBHBkc88+dG2gST3wU9_s_qA@mail.gmail.com> |
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@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
[email protected] / (31) 3277-7114