[firebird-support] Single trans per connection?

2012-06-08 Thread Kjell Rilbe
Hi, Please remind me, is it the case that you can only have a single active transaction per connection? But you can have any number of commands/queries open for that single transaction and connection? This is in .Net and I'm using the FB provider version 2.6 or 2.7 I think. Kjell --

Re: [firebird-support] Single trans per connection?

2012-06-08 Thread Mark Rotteveel
On Fri, 8 Jun 2012 11:45:01 +0200, Kjell Rilbe kjell.ri...@datadia.se wrote: Hi, Please remind me, is it the case that you can only have a single active transaction per connection? Technically Firebird allows you to use multiple, concurrent transaction on a single connection, however not

Re: [firebird-support] Single trans per connection?

2012-06-08 Thread Helen Borrie
At 09:45 PM 8/06/2012, Kjell Rilbe wrote: Hi, Please remind me, is it the case that you can only have a single active transaction per connection? Absolutely not the case! But you can have any number of commands/queries open for that single transaction and connection? You can have any number

Re: [firebird-support] Single trans per connection?

2012-06-08 Thread Kjell Rilbe
Den 2012-06-08 12:04 skrev Helen Borrie såhär: your question is for the firebird-net-provider list. I'd be extremely surprised if, this far on in its life, the .net provider didn't fully support the Firebird API. Well, it actually does seem like concurrent transactions are NOT supported,

Re: [firebird-support] Single trans per connection?

2012-06-08 Thread Ann Harrison
On Fri, Jun 8, 2012 at 7:46 AM, Michael Ludwig mil...@gmx.de wrote: Kjell Rilbe schrieb am 08.06.2012 um 13:06 (+0200): Den 2012-06-08 12:04 skrev Helen Borrie såhär: the .net provider […] the Firebird API. Well, it actually does seem like concurrent transactions are NOT supported, as