I am using the Firebird .Net driver for database io in Visual Studio 2005 .Net 2.0 C#. I have three different threads accessing data. I keep getting "Dynamic SQL Error" Exceptions. The error is fairly random but usually involves an odd character out of place for a field or table name, resulting in an error. I have tried using a separate connections for each thread, and I have tried putting all database IO inside Monitor.Enter()/Monitor.Exit blocks, but the error still occurs. If I put all my code into one thread and run things sequentially the errors go away. I get these errors using a server or embedded. As far as I can tell, this type of access should be safe as long as I use a unique connection in each thread. I have tried the some thing with SQL Server 2005 but could not duplicate the error.
Is there a thread-safe way to access data using Firebird .Net? ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
