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

Hello, Hiroshi.

follow exits:

[root(at)pcenterdev ~]# ldd -r /usr/lib64/psqlodbcw.so
linux-vdso.so.1 => (0x00007fffa99f7000)
libssl.so.10 => /lib64/libssl.so.10 (0x00007f837133a000)
libpq.so.5 => /lib64/libpq.so.5 (0x00007f837110b000)
libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f8370eee000)
libodbcinst.so.2 => /lib64/libodbcinst.so.2 (0x00007f8370cdc000)
libc.so.6 => /lib64/libc.so.6 (0x00007f8370919000)
libgssapi_krb5.so.2 => /lib64/libgssapi_krb5.so.2
(0x00007f83706ca000)
libkrb5.so.3 => /lib64/libkrb5.so.3 (0x00007f83703e3000)
libcom_err.so.2 => /lib64/libcom_err.so.2 (0x00007f83701df000)
libk5crypto.so.3 => /lib64/libk5crypto.so.3 (0x00007f836ffac000)
libcrypto.so.10 => /lib64/libcrypto.so.10 (0x00007f836fbc2000)
libdl.so.2 => /lib64/libdl.so.2 (0x00007f836f9be000)
libz.so.1 => /lib64/libz.so.1 (0x00007f836f7a7000)
libldap_r-2.4.so.2 => /lib64/libldap_r-2.4.so.2 (0x00007f836f54b000)
/lib64/ld-linux-x86-64.so.2 (0x00007f8371836000)
libltdl.so.7 => /lib64/libltdl.so.7 (0x00007f836f341000)
libkrb5support.so.0 => /lib64/libkrb5support.so.0
(0x00007f836f131000)
libkeyutils.so.1 => /lib64/libkeyutils.so.1 (0x00007f836ef2d000)
libresolv.so.2 => /lib64/libresolv.so.2 (0x00007f836ed13000)
liblber-2.4.so.2 => /lib64/liblber-2.4.so.2 (0x00007f836eb03000)
libsasl2.so.3 => /lib64/libsasl2.so.3 (0x00007f836e8e6000)
libssl3.so => /lib64/libssl3.so (0x00007f836e6a2000)
libsmime3.so => /lib64/libsmime3.so (0x00007f836e47b000)
libnss3.so => /lib64/libnss3.so (0x00007f836e155000)
libnssutil3.so => /lib64/libnssutil3.so (0x00007f836df28000)
libplds4.so => /lib64/libplds4.so (0x00007f836dd24000)
libplc4.so => /lib64/libplc4.so (0x00007f836db1f000)
libnspr4.so => /lib64/libnspr4.so (0x00007f836d8e0000)
libselinux.so.1 => /lib64/libselinux.so.1 (0x00007f836d6b9000)
libcrypt.so.1 => /lib64/libcrypt.so.1 (0x00007f836d481000)
librt.so.1 => /lib64/librt.so.1 (0x00007f836d279000)
libpcre.so.1 => /lib64/libpcre.so.1 (0x00007f836d017000)
libfreebl3.so => /lib64/libfreebl3.so (0x00007f836ce14000)

[root(at)pcenterdev ~]# ldd -r /usr/bin/isql
linux-vdso.so.1 => (0x00007ffd4f56d000)
libodbc.so.2 => /lib64/libodbc.so.2 (0x00007f5c135d5000)
libltdl.so.7 => /lib64/libltdl.so.7 (0x00007f5c133cb000)
libreadline.so.6 => /lib64/libreadline.so.6 (0x00007f5c13184000)
libdl.so.2 => /lib64/libdl.so.2 (0x00007f5c12f80000)
libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f5c12d64000)
libc.so.6 => /lib64/libc.so.6 (0x00007f5c129a0000)
libtinfo.so.5 => /lib64/libtinfo.so.5 (0x00007f5c12776000)
/lib64/ld-linux-x86-64.so.2 (0x00007f5c13845000)

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

2018-09-06 21:22 GMT-03:00 Inoue, Hiroshi <h-inoue(at)dream(dot)email(dot)ne(dot)jp>:

> 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
> <https://maps.google.com/?q=Av.+Presidente+Carlos+Luz,1275&entry=gmail&source=g>
>
> joaof(at)pbh(dot)gov(dot)br / (31) 3277-7114
>
>
>
>
>
>
>
>
>
> <http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient> ウイルス
> フリー｡ www.avg.com
> <http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient>
> <#m_-4475579965520039498_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>