firebird-net-provider

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

[Andrew G. <ag...@jc...>]

The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material.  If the reader of this message is not the intended recipient,
you are hereby notified that your access is unauthorized, and any review,
dissemination, distribution or copying of this message including any
attachments is strictly prohibited.   If you are not the intended
recipient, please contact the sender and delete the material from any
computer.

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.