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

2007-10-09 Thread Carlos
Hello: Is there a thread-safe way to access data using Firebird .Net? ADO.NET Data Providers aren't thread-safe, you should be using a connection per thread. -- Carlos Guzmán Álvarez Vigo-Spain Blog: http://carlosga.wordpress.com/ FirebirdClient : http://www.firebirdsql.org/

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 am

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

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

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 error is fairly

[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] 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

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:

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 will

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: 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

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

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
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