If the exception is coming back as a FbException, isn't there an Errors
property that is a list of FbError objects?  If I'm remembering
correctly the FbError contains more detailed information (message, line
number, column number, etc).

 

 

Josh Williams

Applications Developer

Software Computer Group

 

From: Russell Rose [mailto:russ...@passfield.co.uk] 
Sent: Tuesday, January 12, 2010 11:13 AM
To: firebird-net-provider@lists.sourceforge.net
Subject: [Firebird-net-provider] ExecuteReader fails with code 335544327

 

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

No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 9.0.725 / Virus Database: 270.14.135/2615 - Release Date:
01/12/10 02:35:00

------------------------------------------------------------------------------
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