Received: from mx-1.sollentuna.net (mx-1.sollentuna.net [195.67.128.9]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5NHUra75314 for ; Sat, 23 Jun 2001 13:30:55 -0400 (EDT) (envelope-from mha@sollentuna.net) Received: from melissa.edu.sollentuna.se (melissa.edu.sollentuna.se [172.16.1.35]) by mx-1.sollentuna.net (Postfix) with SMTP id 95B2F18014 for ; Sat, 23 Jun 2001 18:39:07 +0200 (CEST) Received: FROM argon.edu.sollentuna.se BY melissa.edu.sollentuna.se ; Sat Jun 23 18:39:07 2001 +0200 X-MimeOLE: Produced By Microsoft Exchange V6.0.4418.65 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Subject: RE: firehouse Date: Sat, 23 Jun 2001 18:39:07 +0200 Message-ID: <81124B76C0CF364EBAC6CD213ABEDEF701AA39@ARGON.edu.sollentuna.se> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [SQL] firehouse Thread-Index: AcD7NQbg7f09+w6yRa2vICA7d1gAkwAzcHJA From: "Magnus Hagander" To: "Ross J. Reedstrom" , "sbelow" Cc: Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by postgresql.org id f5NHUwa75951 X-Archive-Number: 200106/391 X-Sequence-Number: 3688 > On Wed, Jun 20, 2001 at 07:37:39PM +0000, sbelow wrote: > > getting this error "Transaction cannot start while in > firehouse mode." I > > can't find in the books what this is trying to tell me. > > new at dbs. > > That message is not coming from PostgreSQL, I've grepped the > source tree: > > $ find . -name \*.[chyl] | xargs grep -i 'fireh' > $ > > What's your software environment? The error must be coming from some > other layer. "firehose cursor" is Microsoft lingo for "server-side, forward-scrolling, read-only cursor". The solution is to change cursor mode if you need to be able to start a transaction, or make sure that *all* recordsets associated with the connectino are closed before you execute the .BeginTrans method. See example 2 in http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnproas p/html/tipsforworkingwithcursors.asp //Magnus