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