Subject | Re: Database file remains locked when connection is closed |
---|---|
Author | psylencedave |
Post date | 2011-08-25T07:51:41Z |
> At first look, i would say that the connection-pooling of .NET ProviderBrilliant! That was the solution to the problem. Setting pooling to false enables the file to be modified immediately after the connection is closed.
> is enabled (by default). Therefore, the .Close() command does not really
> disconnect from the file. It just put the opened connection back to the
> pool. Try to add
>
> cs.Pooling = false;
>
>
> to your Connection-String.
> Be aware: connection pooling is not a bad thing for a production system.
> But it's maybe the problem in your test.
Thanks you so much!