[Firebird-net-provider] What transaction handle is needed for SET TRANSACTION statement?

2007-08-10 Thread Bryan Pendleton
Hi, I tried to issue the statement SET TRANSACTION LOCK TIMEOUT 5 by calling FbCommand.ExecuteNonQuery(), and I received the error: invalid transaction handle (expecting explicit transaction start) What does this error mean? Immediately prior to calling ExecuteNonQuery, I set the Trans

Re: [Firebird-net-provider] Where can I learn more about FbConnection.ClearAllPools

2007-08-02 Thread Bryan Pendleton
Thanks Jiri! This is very helpful. > Well, I suppose you know how connection pooling works. In principle, yes. In the specific case of FbConnection, is connection pooling performed automatically? Or is is something that I would need to configure and enable in my application? That is, how do I k

[Firebird-net-provider] Where can I learn more about FbConnection.ClearAllPools

2007-08-01 Thread Bryan Pendleton
I was looking at the FbConnection documentation and I saw a bit about the ClearAllPools method: http://www.firebirdsql.org/dotnetfirebird/documentation/api/1.7/FirebirdSql.Data.Firebird.FbConnection.ClearAllPools.html Is there any more information available about this method, such as: - when I w

[Firebird-net-provider] Newbie questions about .Net provider and thread safety

2007-07-13 Thread Bryan Pendleton
Hi all, I'm just getting started with the FB .Net provider, so please excuse me if these are dumb questions: 1) Is FbConnection thread safe? Can two threads make calls on the same connection at the same time? If not, can different threads serially re-use the connection (first one thread uses it, t