Re: [Firebird-net-provider] fbTransactionoptions

2009-05-23 Thread Jiri Cincura
2009/5/11 Ivan Arabadzhiev : > 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 old. > Or am I

Re: [Firebird-net-provider] fbTransactionoptions

2009-05-11 Thread Ivan Arabadzhiev
Mon, 11 May 2009 17:46:31 +0300, Jiri Cincura : > 2009/5/11 Ivan Arabadzhiev : >> 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 ..

Re: [Firebird-net-provider] fbTransactionoptions

2009-05-11 Thread Jiri Cincura
2009/5/11 Ivan Arabadzhiev : > 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 a table of ID`s t

Re: [Firebird-net-provider] fbTransactionoptions

2009-05-11 Thread Ivan Arabadzhiev
Mon, 11 May 2009 14:24:16 +0300, Jiri Cincura : > 2009/5/11 Ivan Arabadzhiev : >>  public FbTransaction BeginTransaction(FbTransactionOptions options, >> string transactionName) >> >> overload of the function, but according to google fb 2.1 checks the >> header >> in a different way than fb 2.0.

Re: [Firebird-net-provider] fbTransactionoptions

2009-05-11 Thread Ivan Arabadzhiev
Fri, 08 May 2009 19:03:12 +0300, Jiri Cincura : > 2009/5/8 Ivan Arabadzhiev : >> 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 so

Re: [Firebird-net-provider] fbTransactionoptions

2009-05-11 Thread Jiri Cincura
2009/5/11 Ivan Arabadzhiev : >  public FbTransaction BeginTransaction(FbTransactionOptions options, > string transactionName) > > overload of the function, but according to google fb 2.1 checks the header > in a different way than fb 2.0. Is anyone else using this method (or am I > a lot dummer tha

Re: [Firebird-net-provider] fbTransactionoptions

2009-05-08 Thread Jiri Cincura
2009/5/8 Ivan Arabadzhiev : > 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 parameters (I did ask >

Re: [Firebird-net-provider] fbTransactionoptions

2009-05-08 Thread Ivan Arabadzhiev
Thu, 07 May 2009 15:09:31 +0300, 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

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

[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