Re: [Firebird-net-provider] Firebird and Threads

2007-10-12 Thread Peter Gissel
I was hoping someone might have some info or insight on this problem. I can easily repeat this with a sample database and a small sample program running three different threads. Each thread has it's OWN connection, so three threads, three connections. I can even put locking around the adapter.F

Re: [Firebird-net-provider] Firebird and Threads

2007-10-09 Thread Peter Gissel
"Dean Harding" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Peter Gissel wrote: >> 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 err

Re: [Firebird-net-provider] Firebird and Threads

2007-10-08 Thread Carlos
Hello: > Is there a thread-safe way to access data using Firebird .Net? ADO.NET Data Providers aren't thread-safe, you should be using a connection per thread. -- Carlos Guzmán Álvarez Vigo-Spain Blog: http://carlosga.wordpress.com/ FirebirdClient : http://www.firebirdsql.org/ XMP

Re: [Firebird-net-provider] Firebird and Threads

2007-10-08 Thread Dean Harding
Peter Gissel wrote: > 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 fie

[Firebird-net-provider] Firebird and Threads

2007-10-08 Thread Peter Gissel
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