HI there

I am connecting to a Firebird database via a mobile device running Windows CE 
and using .net v2.  I regularly get the above error code.  Here is some 
pseudocode for what I am doing:

using (FbTransaction CentralTrans = 
((FbConnection)centralConn).BeginTransaction()) {
    using (FbCommand centralCmd = ((FbConnection)centralConn).CreateCommand()) {
        centralCmd.Transaction = CentralTrans;

        // I then repeat the following lots of times
        FbDataReader reader = null;
        centralCmd.CommandText = "some sql";
                     reader = centralCmd.ExecuteReader();

        // and finally
        CentralTrans.Commit();
    }
}

I am putting everything into a try/catch and then a while loop for retrying

If I put the ExecuteReader into a loop for retry with a 1sec delay I just get 
the same error repeated.  Is there a way to 1) Get more information as to what 
is going wrong, 2) put in a retry mechanism that will give a better chance of 
success on a failure
------------------------------------------------------------------------------
This SF.Net email is sponsored by the Verizon Developer Community
Take advantage of Verizon's best-in-class app development support
A streamlined, 14 day to market process makes app distribution fast and easy
Join now and get one step closer to millions of Verizon customers
http://p.sf.net/sfu/verizon-dev2dev 
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Reply via email to