Dear Sir,
I had some problem with configured the ODBC. I worked on MS Access97 and
ASP as frontend and use database on Postgres via ODBC. It used to work well
til the Postgres Db was upgraded to 6.5.1 version. Now,I use Postodbc
6.40.0007. ^^^^^^
^^^^^^^^^^
The error message which I got from psqlodbc.log is
conn=97458576, SQLDriverConnect( in)='DSN=access2; UID=nuchk;
PWD=araigodai;', fDriverCompletion=0
DSN info:
DSN='access2',server='myserver.co.th',port='5432',dbase='mydb',user='myname',passwd='mypass'
readonly='1',protocol='6.4',showoid='0',fakeoidindex='0',showsystable='0' conn_settings=''
translation_dll='',translation_option=''
Global Options: Version='06.40.0007', fetch=100, socket=4096,
unknown_sizes=0, max_varchar_size=254, max_longvarchar_size=8190 disable_optimizer=1, ksqo=1,
unique_index=0,
use_declarefetch=0 text_as_longvarchar=1, unknowns_as_longvarchar=0,
bools_as_char=1 extra_systable_prefixes='dd_;', conn_settings=''
conn=97458576, query=' '
conn=97458576, query='set DateStyle to 'ISO''
conn=97458576, query='set geqo to 'OFF''
conn=97458576, query='set ksqo to 'ON''
conn=97458576, query='select oid from pg_type where typname='lo'' [ fetched 0 rows ]
conn=97458576,
SQLDriverConnect(out)='DSN=access2;DATABASE=access;SERVER=safari.inet.co.th;PORT=5432;UID=nuchk;PWD=araigodai;READONLY=1;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS='
CONN ERROR: func=SQLGetInfo, desc='', errnum=209, errmsg='Unrecognized key passed to SQLGetInfo.'
------------------------------------------------------------ henv=97453632, conn=97458576,
status=1,num_stmts=16 sock=97453648, stmts=97453696, lobj_type=-999 ---------------- Socket Info
------------------------------- socket=2948, reverse=0, errornumber=0, errormsg='(null)'
buffer_in=97464912,buffer_out=97469016 buffer_filled_in=33, buffer_filled_out=0, buffer_read_in=32
I've tried so many times both re-install the previos version and
psqlodbc.dll and re-config it again follow the instruction which I
retrieved from postgres.org website.
I'm always got this error 'Unrecognized key passed to SQLGetInfo.'
what's the key I have to send? please help.
Hope to hear from you all soon.
Thanx,
Nuch
-----------------------------------------
Nuchanach Klinjun
R&D Project. Internet Thailand
Email: nuchk@inet.co.th