So, if I understand this correctly.. For each request that my .Net application processes, I should create a new FBConnection object with the connection string I am currently using. My current code only creates the FBConnection for each session.
Phillip -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jiri Cincura Sent: Tuesday, October 09, 2007 2:38 PM To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] Connection Pooling On 10/9/07, Phillip M. Day <[EMAIL PROTECTED]> wrote: > Do you mind pointing me towards a sample project or code that I can > reference? Try to run one and more instances and see how many connections you see in DB when pooling is true and when false. class Program { static void Main(string[] args) { Test1(); Console.ReadKey(); } private static void Test1() { using (FbConnection conn = new FbConnection(@"data source=localhost;initial catalog=ucime;user id=SYSDBA;password=masterkey;pooling=true")) { conn.Open(); Console.WriteLine("Connection opened ..."); Console.ReadKey(); //conn.Close(); } Console.WriteLine("Connection closed..."); } } -- Jiri {x2} Cincura (Microsoft Student Partner) http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com ------------------------------------------------------------------------ - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Firebird-net-provider mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/firebird-net-provider ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Firebird-net-provider mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
