Re: [Firebird-net-provider] Connection Pooling

2007-10-09 Thread Phillip M. Day
Thank you very much for your help. Phillip -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jiri Cincura Sent: Tuesday, October 09, 2007 5:52 PM To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] Connection Poo

Re: [Firebird-net-provider] Connection Pooling

2007-10-09 Thread Jiri Cincura
On 10/9/07, Phillip M. Day <[EMAIL PROTECTED]> wrote: > 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

Re: [Firebird-net-provider] Connection Pooling

2007-10-09 Thread Phillip M. Day
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 PRO

Re: [Firebird-net-provider] Connection Pooling

2007-10-09 Thread Jiri Cincura
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(s

Re: [Firebird-net-provider] Connection Pooling

2007-10-09 Thread Phillip M. Day
Do you mind pointing me towards a sample project or code that I can reference? Thanks in advance. Phillip -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jiri Cincura Sent: Tuesday, October 09, 2007 1:23 PM To: For users and developers of the Firebird .

Re: [Firebird-net-provider] Connection Pooling

2007-10-09 Thread Jiri Cincura
On 10/9/07, Phillip M. Day <[EMAIL PROTECTED]> wrote: > I guess that is what I am asking. How do I use a connection pool? You already has "Pooling=true" in connection string. So just open/close connections where you need. Try to open at least as possible and close as fast as possbile. Provider wi

Re: [Firebird-net-provider] Connection Pooling

2007-10-09 Thread Phillip M. Day
I guess that is what I am asking. How do I use a connection pool? Phillip -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jiri Cincura Sent: Tuesday, October 09, 2007 12:45 PM To: For users and developers of the Firebird .NET providers Subject: Re: [Fire

Re: [Firebird-net-provider] Connection Pooling

2007-10-09 Thread Jiri Cincura
Why not to create connection(s) where you need and use connection pool? IMO saving object to the session is a really bad idea. -- Jiri {x2} Cincura (Microsoft Student Partner) http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com --

[Firebird-net-provider] Connection Pooling

2007-10-09 Thread Phillip Day
I am fairly new to .Net and would like to understand a "best practice" of using Firebird in my .Net project. I have a web application that we are converting from CGI to .NET. The CGI application establishes a connection for every request. When architecting the .Net application, would the best

Re: [Firebird-net-provider] Firebird and Threads

2007-10-09 Thread Peter Gissel
"Dean Harding" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Peter Gissel wrote: >> I am using the Firebird .Net driver for database io in Visual Studio 2005 >> .Net 2.0 C#. I have three different threads accessing data. I keep >> getting >> "Dynamic SQL Error" Exceptions. The err

Re: [Firebird-net-provider] Remote Connection Problem

2007-10-09 Thread Phillip M. Day
Yes, sure does. Phillip -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jiri Cincura Sent: Tuesday, October 09, 2007 2:48 AM To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] Remote Connection Problem On 10/8

Re: [Firebird-net-provider] Remote Connection Problem

2007-10-09 Thread Carlos
Hello: > I am using the .Net 2.0 provider in RAD Studio 2007. I am able to connect > to a local database but when I try to enter the remote IP in the Data Source > field and the path to the DB in the database field, I get a message "Unable > to complete network request to host xx.xx.xx.xx" > > I

Re: [Firebird-net-provider] Remote Connection Problem

2007-10-09 Thread Jiri Cincura
On 10/8/07, Phillip Day <[EMAIL PROTECTED]> wrote: > I am using the .Net 2.0 provider in RAD Studio 2007. I am able to connect > to a local database but when I try to enter the remote IP in the Data Source > field and the path to the DB in the database field, I get a message "Unable > to complete