Skip site navigation (1) Skip section navigation (2)

ODBC

From: Nuchanach Klinjun <nuchk(at)inet(dot)co(dot)th>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: ODBC
Date: 1999-09-14 09:31:53
Message-ID: Pine.OSF.4.10.9909141619570.17952-100000@johann.inet.co.th (view raw or flat)
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


pgsql-interfaces by date

Next:From: Nuchanach KlinjunDate: 1999-09-14 09:46:41
Subject: Need Help with ODBC Problem!
Previous:From: Dmitry A BrutckevichDate: 1999-09-14 09:17:41
Subject: SERIAL type in PHP

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group