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.
------------------------------------------------------------------------------
Throughout its 18-year history, RSA Conference consistently attracts the
world's best and brightest in the field, creating opportunities for Conference
attendees to learn about information security's most important issues through
interactions with peers, luminaries and emerging and established companies.
http://p.sf.net/sfu/rsaconf-dev2dev
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
