John Martinez wrote:
> <add name="MyConnString"
> connectionString=
>
> "userid=SYSDBA;password=masterkey;database=c:\mydb.fdb;datasource=Localhost;port=3050;charset=NONE;Role=;Connection
>
> lifetime=0;Connection
> timeout=15;Pooling=True;MinPoolSize=10;MaxPoolSize=20;Connection
> Lifetime=5;dialect=1;Packet Size=8192;server type=0;"
> providerName="FirebirdSql.Data.FirebirdClient"/>
>
I would suggest you remove the connection pooling stuff from the
connection string. Connection pooling is on by default, and the default
parameters have been chosen to provide the best results in most situations.
> The simple code below is similar to what I'm calling to open / close a
> connection when needed:
>
> procedure Ttest.Page_Load(sender: System.Object; e: System.EventArgs);
> var
> conn : FirebirdSql.Data.FirebirdClient.FbConnection;
> begin
> // TODO: Put user code to initialize the page here
> conn := FirebirdSql.Data.FirebirdClient.FbConnection.Create;
> conn.ConnectionString :=
> System.Configuration.ConfigurationManager.ConnectionStrings['MyConnString'].ToString;
> conn.Open;
> Response.Write ('Connection open<BR>');
> Response.Write ('Connection Pools Count = ' +
> conn.ConnectionPoolsCount.ToString + '<BR>');
> conn.Close;
> Response.Write('Connection close<BR>');
> Response.Write('Connection Pools Count = ' +
> conn.ConnectionPoolsCount.ToString + '<BR>');
Assuming you do an actual database call between the open and close, then
yes, that is the correct way to be doing it.
Dean.
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
