Re: [Firebird-net-provider] Firebird Client error during Fetch cycle

[Russell R <Ru...@pa...>]

Here is some cut down code that can repo the error (only when connected via
the LAN).  I put it in program.cs:
namespace test
{
    class Program
    {
        [MTAThread]
        static void Main() {
            FbConnection centralConn = null;
            FbDataReader reader = null;
            FbCommand centralCmd = null;
            int rowcnt = 0;
            try {
                string connstr =
@"Server=192.168.2.112;User=XXXXXX;Password=YYYYYY;Database=c:\demodata.fdb;Charset=UTF8";
                string selcmd = @"SELECT
UNIQUE_KEY,BATCH_NO,EVENT_TYPE,ACTUAL_DATE,STATUS,ENVIRONMENT_CODE,NURSERY_KEY,AREA_KEY,ACTUAL_BATCH_QTY,ACTUAL_SPACE_UNITS,SPACING_METHOD,TRAY_TYPE,PLANTS_PER_SPACE_UNIT,MADE_ACTUAL_BY,EVENT_FUNCTION,WASTE_OR_ADJUST_PCENT,SEQUENCE,PRIOR_PLANTS_PER_UNIT
FROM BATCH_EVENT";
                centralConn = new FbConnection(connstr);
                centralConn.Open();
                centralCmd = ((FbConnection)centralConn).CreateCommand();
                centralCmd.CommandText = selcmd;
                reader = centralCmd.ExecuteReader();
                while (reader.Read()) {
                    rowcnt++;
                }
            }
            catch (Exception e) {
                MessageBox.Show(e.ToString());
            }
            MessageBox.Show("rows read: "+rowcnt.ToString());
            reader.Close();
            reader.Dispose();
            centralCmd.Dispose();
            centralConn.Close();
            centralConn.Dispose();
        }
    }
}
Russell Rose
Passfield Data Systems Ltd
Tel: +44 1404 514401

-- 
View this message in context: http://old.nabble.com/Firebird-Client-error-during-Fetch-cycle-tp27213450p27224127.html
Sent from the firebird-net-provider mailing list archive at Nabble.com.