Received: from u1.abs.net (root@u1.abs.net [207.114.0.131]) by hub.org (8.9.2/8.9.1) with ESMTP id JAA35674 for ; Wed, 24 Mar 1999 09:44:34 -0500 (EST) (envelope-from byronn@insightdist.com) Received: from insightdist.com (nobody@localhost) by u1.abs.net (8.9.0/8.9.0) with UUCP id JAA26981 for pgsql-interfaces@hub.org; Wed, 24 Mar 1999 09:40:43 -0500 (EST) X-Authentication-Warning: u1.abs.net: nobody set sender to insightdist.com!byronn using -f Received: from ceodev by insightdist.com (AIX 3.2/UCB 5.64/4.03) id AA14679; Wed, 24 Mar 1999 09:17:03 -0500 Received: from byronn by ceodev (AIX 4.1/UCB 5.64/4.03) id AA19816; Wed, 24 Mar 1999 09:17:03 -0500 Message-Id: <36F8F59C.476D3270@insightdist.com> Date: Wed, 24 Mar 1999 09:24:28 -0500 From: Byron Nikolaidis X-Mailer: Mozilla 4.05 [en] (Win95; I) Mime-Version: 1.0 To: Daniel Cc: pgsql-interfaces@hub.org Subject: Re: [INTERFACES] why there's only char type? References: <001901be7653$06b15280$87f1b9ca@dvader.ids.org.my> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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 PB050 fffb7063:fffc2b73 EXIT SQLGetTypeInfo with return code 0 (SQL_SUCCESS) HSTMT 0x013a0d44 SWORD 0 PB050 fffb7063:fffc2b73 ENTER SQLSetStmtOption HSTMT 0x013a0d44 UWORD 9 UDWORD 16 PB050 fffb7063:fffc2b73 EXIT SQLSetStmtOption with return code 1 (SQL_SUCCESS_WITH_INFO) HSTMT 0x013a0d44 UWORD 9 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=''