Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.4) with SMTP id f7EDtGP19760 for ; Tue, 14 Aug 2001 09:55:16 -0400 (EDT) (envelope-from pgsql-odbc-owner@postgresql.org) Received: from gw.heart.com.au (mail.heart.com.au [203.12.235.237]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f7E2EJP96705 for ; Mon, 13 Aug 2001 22:14:20 -0400 (EDT) (envelope-from keith@heart.com.au) Received: from tardis.heart.com.au (IDENT:root@tardis.heart.com.au [192.168.0.42]) by gw.heart.com.au (8.9.3/8.9.3) with ESMTP id MAA00603; Tue, 14 Aug 2001 12:19:53 +1000 Received: from heart.com.au ([192.168.0.87]) by tardis.heart.com.au (8.9.3/8.8.7) with ESMTP id MAA24752; Tue, 14 Aug 2001 12:14:10 +1000 Message-ID: <3B78896A.6230BB6A@heart.com.au> Date: Tue, 14 Aug 2001 12:14:02 +1000 From: Keith Gray X-Mailer: Mozilla 4.76 [en] (Win98; U) X-Accept-Language: en MIME-Version: 1.0 To: Hiroshi Inoue CC: "pgsql-odbc@postgresql.org" Subject: Re: ODBC 7.1 References: <3B7347F7.AE509D5D@heart.com.au> <3B734DA7.29F0B8BE@tpf.co.jp> <3B734FCC.1C7C3FB2@heart.com.au> <3B7352A7.EF2CD469@tpf.co.jp> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200108/24 X-Sequence-Number: 780 Hiroshi Inoue wrote: > > Keith Gray wrote: > > > Please download the latest driver 7.01.0006. > Other drivers couldn't handle text fields > 8k. Done that now... > Are you checking the 'Text as LongVarChar' driver option ? Yes. It doesn't look like an ODBC issue now... I have tried all ODBC drivers 6.4, 7.0 and 7.1 with less than 8kb fields and they all seem to have this same problem with timeout. To me this seems like a 7.1 database issue we didn't seem to have with 6.4 and 7.0 Not sure what the timeout is, but I assume a lock condition. -- Keith Gray Technical Development Manager Heart Consulting Services P/L mailto:keith@heart.com.au