From: Byron Nikolaidis <byronn@insightdist.com>
To: Daniel <daniel@ids.org.my>
Cc: pgsql-interfaces@hub.org
Subject: Re: [INTERFACES] why there's only char type?
Date: Wed, 24 Mar 1999 09:24:28 -0500
Message-ID: <36F8F59C.476D3270@insightdist.com> (raw)
References: <001901be7653$06b15280$87f1b9ca@dvader.ids.org.my>
Daniel wrote:
> If you examine the Sql.log, it did call SQLGetTypeInfo(). But the error
> occured when exiting SQLSetStmtOption. Could that be the whole problem? Is
> that a problem of PostODBC or Powerbuilder? Thanks for any help.
>
> Daniel
>
The below excerpt from the log I think reveals the problem. You are using an older version
of the driver (according to the psqlodbc.log -- Version='06.30.0250') that does not support
setting the rowset size to anything greater than 1. You need to get the latest driver!
Go to http://www.insightdist.com/psqlodbc.PB050 fffb7063:fffc2b73 ENTER
SQLGetTypeInfo HSTMT 0x013a0d44
SWORD 0 <SQL_ALL_TYPES>
PB050 fffb7063:fffc2b73 EXIT SQLGetTypeInfo with return code 0 (SQL_SUCCESS)
HSTMT 0x013a0d44
SWORD 0 <SQL_ALL_TYPES>
PB050 fffb7063:fffc2b73 ENTER SQLSetStmtOption
HSTMT 0x013a0d44
UWORD 9 <SQL_ROWSET_SIZE>
UDWORD 16
PB050 fffb7063:fffc2b73 EXIT SQLSetStmtOption with return code 1
(SQL_SUCCESS_WITH_INFO)
HSTMT 0x013a0d44
UWORD 9 <SQL_ROWSET_SIZE>
UDWORD 16
DIAG [01S02] Requested value changed.;
Driver does not support setting this connect option (16)
, fetch=100, socket=4096, unknown_sizes=0, max_varchar_size=254, max_longvarchar_size=4094
disable_optimizer=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=''
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: byronn@insightdist.com, daniel@ids.org.my, pgsql-interfaces@hub.org
Subject: Re: [INTERFACES] why there's only char type?
In-Reply-To: <36F8F59C.476D3270@insightdist.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox