an error during connecting to database - Mailing list pgsql-odbc

From 황성준
Subject an error during connecting to database
Date
Msg-id 000001c28228$a09be830$075648dc@june
Whole thread Raw
List pgsql-odbc
Hi,

I cannot connect to database. I don’t know how to fix the error.

1. my ODBC driver version: 7.02.0003
2. my PostgreSQL database version: 7.2.3
3. an error messages I saw on the screen: none
4. the commlog(psqlodbc_2208.log) file :
--- begin ---
conn=15551496, PGAPI_DriverConnect( in)='DSN=testdb;',
fDriverCompletion=0
DSN info:
DSN='testdb',server='127.0.0.1',port='5432',dbase='testdb',user='hwsj',p
asswd='1'

onlyread='0',protocol='6.4',showoid='0',fakeoidindex='0',showsystable='0
'
          conn_settings='',conn_encoding='OTHER'
          translation_dll='',translation_option=''
Global Options: Version='07.02.0003', fetch=100, socket=4096,
unknown_sizes=0, max_varchar_size=254, max_longvarchar_size=8190
                disable_optimizer=1, ksqo=1, unique_index=1,
use_declarefetch=0
                text_as_longvarchar=1, unknowns_as_longvarchar=0,
bools_as_char=1 NAMEDATALEN=64
                extra_systable_prefixes='dd_;', conn_settings=''
conn_encoding='OTHER'
conn=15551496, query=' '
conn=15551496, query='select version()'
    [ fetched 1 rows ]
    [ PostgreSQL version string = 'PostgreSQL 7.2.3 on i686-pc-cygwin,
compiled by GCC 2.95.3-5' ]
    [ PostgreSQL version number = '7.2' ]
conn=15551496, query='set DateStyle to 'ISO''
conn=15551496, query='set geqo to 'OFF''
conn=15551496, query='select oid from pg_type where typname='lo''
    [ fetched 0 rows ]
conn=15551496, query='select pg_client_encoding()'
    [ fetched 1 rows ]
conn=15551496, query='set client_encoding to 'UHC''
ERROR from backend during send_query: 'ERROR:  Client encoding 'UHC' is
not supported'
    [ Client encoding = 'EUC_KR' (code = 3) ]
CONN ERROR: func=PGAPI_DriverConnect, desc='Error from CC_Connect',
errnum=110, errmsg='(NULL)'
            ------------------------------------------------------------
            henv=15551472, conn=15551496, status=0, num_stmts=16
            sock=15562464, stmts=15570744, lobj_type=-999
            ---------------- Socket Info -------------------------------
            socket=2120, reverse=0, errornumber=0, errormsg='(NULL)'
            buffer_in=15562536, buffer_out=15566640
            buffer_filled_in=1, buffer_filled_out=0, buffer_read_in=1
--- end ---
5. the ODBC trace log (sql.log) file: not existed
6. my pg_hba.conf included:
host       all         127.0.0.1     255.255.255.255    password
mypasswd

I hope this error will be fixed.

Regards,
Whang, Seong-Jun


pgsql-odbc by date:

Previous
From: "Dave Page"
Date:
Subject: Re: Known bugs in OBDC?
Next
From: "Antonio Pennino"
Date:
Subject: MFC, CRecordset, crash