Re: [Firebird-net-provider] fbTransactionoptions

2009-05-23 Thread Jiri Cincura
2009/5/11 Ivan Arabadzhiev intelru...@gmail.com: Probably my main problem was that assumption is the mother of all f...@#ups because I read http://www.firebirdsql.org/dotnetfirebird/documentation/api/1.7/FirebirdSql.Data.Firebird.FbTransactionOptions.html This is for version 1.7. It's way too

Re: [Firebird-net-provider] fbTransactionoptions

2009-05-11 Thread Ivan Arabadzhiev
Fri, 08 May 2009 19:03:12 +0300, Jiri Cincura disk...@cincura.net: 2009/5/8 Ivan Arabadzhiev intelru...@unrealsoft.net: Yes, I do mean those, but for example LockRead | Shared throws an exception upon connect. If I use only ReadCommited it`s ok. Could you Use IsolationLevel.ReadCommited and

Re: [Firebird-net-provider] fbTransactionoptions

2009-05-11 Thread Ivan Arabadzhiev
Mon, 11 May 2009 14:24:16 +0300, Jiri Cincura disk...@cincura.net: 2009/5/11 Ivan Arabadzhiev intelru...@gmail.com:  public FbTransaction BeginTransaction(FbTransactionOptions options, string transactionName) overload of the function, but according to google fb 2.1 checks the header in a

Re: [Firebird-net-provider] fbTransactionoptions

2009-05-11 Thread Jiri Cincura
2009/5/11 Ivan Arabadzhiev intelru...@gmail.com: well ... pretty much anything I could think of. From what I googled - I need a (Shared | LockRead | NoWait | RecordVersion) transaction. I have tried several variations (consistency, concurency, readcommited ...). It is intended to read through

Re: [Firebird-net-provider] fbTransactionoptions

2009-05-11 Thread Ivan Arabadzhiev
Mon, 11 May 2009 17:46:31 +0300, Jiri Cincura disk...@cincura.net: 2009/5/11 Ivan Arabadzhiev intelru...@gmail.com: well ... pretty much anything I could think of. From what I googled - I need a (Shared | LockRead | NoWait | RecordVersion) transaction. I have tried several variations

Re: [Firebird-net-provider] fbTransactionoptions

2009-05-08 Thread Ivan Arabadzhiev
Thu, 07 May 2009 15:09:31 +0300, Jiri Cincura disk...@cincura.net: The FbTransactionOptions has no valid combinations. It's just a holder for transaction params. Maybe you mean FbTransactionBehavior. There you have Consistency = 1, Concurrency = 2, Shared = 4,

Re: [Firebird-net-provider] fbTransactionoptions

2009-05-08 Thread Jiri Cincura
2009/5/8 Ivan Arabadzhiev intelru...@unrealsoft.net: Yes, I do mean those, but for example LockRead | Shared throws an exception upon connect. If I use only ReadCommited it`s ok. Could you Use IsolationLevel.ReadCommited and that's OK. paste a link to some kind of documentation on those

[Firebird-net-provider] fbTransactionoptions

2009-05-07 Thread Ivan Arabadzhiev
It`s not actually a provider issue but I was unable to find documentation on the available valid combinations of options, and I can`t really find a reason why firebird doeasn`t like my combinations... can anyone give a hand or should I continue in (the not really successful) trial-and-error

Re: [Firebird-net-provider] fbTransactionoptions

2009-05-07 Thread Jiri Cincura
The FbTransactionOptions has no valid combinations. It's just a holder for transaction params. Maybe you mean FbTransactionBehavior. There you have Consistency = 1, Concurrency = 2, Shared = 4, Protected = 8, Exclusive = 16, Wait = 32, NoWait