problem with SQLGetInfo
От | Nuchanach Klinjun |
---|---|
Тема | problem with SQLGetInfo |
Дата | |
Msg-id | Pine.OSF.4.10.9909141648470.18748-100000@johann.inet.co.th обсуждение исходный текст |
Список | pgsql-hackers |
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
В списке pgsql-hackers по дате отправления: