Re: [Firebird-net-provider] interbase user physical connection not disconnecting.

[Carlos G. A. <car...@te...>]

Hello:

> Thank you all for the previous help you have provided - you have been a 
> real help getting me up and going. I can now select, update, insert, etc 
> as desired from my asp.net webform to my interbase db.
>  
> My question is concerning the physical disconnecting from the database. 
> In my code I make sure I dispose the Transaction, Command and Close the 
> Connection.
> Everything appears to be fine, I receive no exceptions on the dotnet 
> side. But when I go to Interbase I view the connected users it still 
> shows the user connected.
> The user will only disconnect after I recycle IIS 5.0.
>  
> Any ideas why the user will not disconnect from the database?
> Is this related to connection pooling and/or garbage collection in dotnet?
>  
> Below are snipets of VB.Net code examples I use to connect and disconnect.


This seems to be a problem with Connection Pooling, you can set in 
connection string the Connection Pooling off, default is on, or change 
the Connection Lifetime, default is 0.







-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.