BoolsAsChar

From: Eric Hallander <ehallander(at)tellium(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: BoolsAsChar
Date: 2002-12-12 22:30:24
Message-ID: 05707214338CD5119BFF0040A5B170D30259563B@mail3.tellium.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

I am running the same version of the libodbcpsql.sl on two different
machines, and for some unknown reason the values in odbc.ini are being
ignored with regard to the BoolsAsChar setting.

I turned CommLog on on both machines, and see the trace from both
executions. On the good machine the bools_as_char setting reflects its
odbc.ini setting, and on the bad machine it always shows as 1.

I have been racking my brain trying to remember all the things I did on the
development machine to get my odbc library stuff working, and maybe I am
just missing something on the IT machine.


Bad Machine Output:
conn = 1073859256, PGAPI_Connect(DSN='EMSADM', UID='emsadm', PWD='')
Global Options: Version='07.01.0009', fetch=100, socket=4096,
unknown_sizes=0, max_varchar_size=254, max_longvarc
har_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
extra_systable_prefixes='dd_;', conn_settings=''



Good Machine output
conn = 1073859120, PGAPI_Connect(DSN='Eric', UID='eric', PWD='')
Global Options: Version='07.01.0009', 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=0
extra_systable_prefixes='dd_;', conn_settings=''


Any Ideas

Eric

Eric Hallander
Tellium Inc.
2 Crescent Place
Oceanport, NJ 07757
(732) 483-2922
(732) 923-9804 FAX
mailto:ehallander(at)tellium(dot)com <mailto:ehallander(at)tellium(dot)com>
http://www.tellium.com <http://www.tellium.com/>

Browse pgsql-odbc by date

  From Date Subject
Next Message Matt Clark 2002-12-12 23:38:51 Re: BoolsAsChar
Previous Message Jerry Quarry 2002-12-11 05:53:28 unsubscribe