Hi,
I've found no way to use the new FB 2 feature of
SET TRANSACTION LOCK TIMEOUT X
from the .Net data provider. The server always gives me
'invalid transaction handle (expecting explicit transaction start)' exceptions.
How can I use this feature? I would like to have this setting on a
connection base (at connection creation time the value X is known
and not changed later).
Any help appreciating,
Thomas
=== CODE ===
FbConnection c = new FbConnection(theConnectionString);
c.Open();
FbTransaction t = c.BeginTransaction();
if (t != null)
{
using (FbCommand cmd = c.CreateCommand())
{
cmd.CommandText = "SET TRANSACTION LOCK TIMEOUT 1000";
cmd.Transaction = t;
cmd.ExecuteNonQuery();
}
t.Rollback();
}
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
