[Firebird-net-provider] BeginTransaction Problem ??

[<meg...@ya...>]

Hello All,
  I've been looking into this mail archive for quite some time. And really I've learnt a lot. Thanx to Carlos and other people.
 As of now I'm using Firebird .NET Provider Beta 2 over Firebird 1.5 RC3 vesrion, and eagerly waiting for their final releases so that I can use my product in production environment.
 I was goin' thru the archive, I got thru this query posted by Thomas. To my surprise, this is the same kind of problem I'm facing and haven't been able to solve it. 
In my applicaton, I've two daemon threads that keep on pumping data in the database from a remote database. And there are couple of other threads, which have nothing else to do but just query this database for all sorts of averages. All the queries to the database are via stored procedures and there is no direct query. Moreover, I've a static class which helps in acquring a connection, executing a query(open txn, execute, close txn) and closing connection. This setup executes very fine on Windows XP, except for the error experienced by Thomas. The problem is not very consistent. Sometimes, it would go for days, without an exception, and sometimes even after few connections, I face this error. I've noticed that this error is more frequent in case of Win2K, than XP. Has anyone else, other than Thomas experienced this exception? Have u come to any solution Thomas?
 
Let me know in case other information is reuqired.
Thanks once a'ain.
Mahesh.
 
Excerpts from Thomas' mail (dated 2003-12-19)  : ------ >
 This log line: 
 Console.WriteLine(eb.Message + " - " + eb.Source + " - " + eb.StackTrace + " - " + eb.InnerException);
 
 prints this message:
 21:54:56.140 - Message: Object reference not set to an instance of an object. - Stacktrace:
   at FirebirdSql.Data.Firebird.Gds.GdsTransaction.BeginTransaction()  at
FirebirdSql.Data.Firebird.FbTransaction.BeginTransaction()    at
FirebirdSql.Data.Firebird.FbConnection.BeginTransaction()    at
Tricon.Funki.PDBServer.DataAccessLogicComponents.LoadStatements.loadAllScaleHavePipe() in
c:\vss\funki\pdbserver\tricon.funki.pdbserver\dataaccesslogiccomponents\loadstatements.cs:line
2509 -  Source: FirebirdSql.Data.Firebird - InnerException:
 
 (The InnerException is empty.)
 
 
 In this test case, the same code runs 288 times.
 In loop 289 the exception arised.
 


---------------------------------
BT Yahoo! Broadband - Free modem offer, sign up online today and save £80