Re: [Firebird-net-provider] fbConnection in Windows Service

[Jiří Č. <ji...@ci...>]

> 2.       Each method creates a local fbConnection
> 
> a.       In this case I get following error:  Enumeration was changed.
> The
> enumeration process can maybe not be performed. (Die Auflistung wurde
> geändert. Der Enumerationsvorgang kann möglicherweise nicht ausgeführt
> werden)

What's the exception stack?
 
> i.  _fbCSB:Pooling := .F.

Why false (I suppose that means false)?

> I understood that fbConnection itself is not threadsafe – 

Correct. The FbConnection object should be used only in single thread
(concurrently). But the pooling is thread safe and threading friendly.
So having it on and keeping the connection opened as short as possible
might help in MT scenarios.

> but I don´t understand which object is alive accross the different calls of the methods of the windows service.

Not sure what you're talking about. 

-- 
Mgr. Jiří Činčura
Independent IT Specialist