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

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(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 <mailto:joaof(at)pbh(dot)gov(dot)br> / (31) 3277-7114
>
>
>
>
>
>

---
このメールは、AVG によってウイルス チェックされています。
http://www.avg.com