[Firebird-net-provider] Timeout expired - problem with connection lifetime

[Ghanshyam P. <gh_...@ya...>]

Hello,
 I have a .Net application. The connection string used
is -

"User=SYSDBA;Password=masterkey;DataSource=localhost;Port=3050;Database=C:\Test.gdb;Dialect=3;Charset=None;Connection
lifetime=30;Pooling=true;"

When i run the application, sometimes i get the error
-

"Timeout expired. The timeout period elapsed prior to
obtaining a connection from the pool. This may have
occurred because all pooled connections were in use
and max pool size was reached."


I am bit confused with connection lifetime and
pooling. Whether its good practice to include
pooling=true. if yes, then what should be the
lifetime?
If i drop the pooling i.e. pooling=false, what effect
will be there on the performance of the application?
i.e if i don't use the pooling at all, then will it be
harmfull?

Thanx in advance for any help.

Regards,
Ghanshyam.

__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com