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

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 (view raw or flat)
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/>  

 

pgsql-odbc by date

Next:From: Matt ClarkDate: 2002-12-12 23:38:51
Subject: Re: BoolsAsChar
Previous:From: Jerry QuarryDate: 2002-12-11 05:53:28
Subject: unsubscribe

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