Need Help with ODBC Problem!

From: Nuchanach Klinjun <nuchk(at)inet(dot)co(dot)th>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: Need Help with ODBC Problem!
Date: 1999-09-14 09:46:41
Message-ID: Pine.OSF.4.10.9909141646160.18962-100000@johann.inet.co.th
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

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(at)inet(dot)co(dot)th

Browse pgsql-interfaces by date

  From Date Subject
Next Message Sean W. Ellis 1999-09-14 16:02:20 Check boxes with Access
Previous Message Nuchanach Klinjun 1999-09-14 09:31:53 ODBC