Dear Cédric

My guess is that it would be possible to write a program to provide what you
need. It would need to be an "Interbase Proxy". Your applications would be
pointed at it, and it would use one connection per database that is
requested. The requests from all the clients could be pooled to run through
one connection from its side.

While this will probably solve your problem from a technical point of view,
I'm not sure how it would align with the licencing conditional for Interbase
7 - I don't have it available, so you'd have to check that out for yourself
(or even better have a lawyer do it for you).

Gary

----- Original Message -----
From: "Cédric JOUBERT" <cejoubert@...>
To: <ib-support@yahoogroups.com>
Sent: Friday, April 25, 2003 12:32 PM
Subject: Re: [ib-support] Share a database connexion


hi, thanks for your reply

> If you are talking about user licences. Then in IB 4.2, it was a 3
> user licence for 3 connections. In IB 5.x, it was 4. In Borland's
> commercial IB 6.x and 7.x, it is 1 user licence. If you need more
> connections, you need to buy more user licences.

In fact, we would like to use the 3 connections for a 1 user licence.
Because i think it is not possible any more with IB 7.0, i wanted to know if
the fact to share a same connection is a good way. The only need i need is
to access a same database with 3 different applications.
I can't be sure to use FireBird so, it is for this reason I ask you that for
Interbase 7.0.

> With IB 7.0 Borland states that the client library is thread safe, so
> you wouldn't require to create a new connection for each thread(not
> the same as an application). This is not the case for IB 6.x.

but concretely, in my case it's for 3 different applications so i don't use
threads ? (sorry I'm not a specialist :-))

--------------------------------
Cédric Joubert
----- Original Message -----
From: Daniel Rail
To: ib-support@yahoogroups.com
Sent: Thursday, April 24, 2003 1:56 PM
Subject: Re: [ib-support] Share a database connexion


Hello Cédric,

Thursday, April 24, 2003, 6:18:51 AM, you wrote:

> Since we are Interbase 4.2 Users, we were using the 3 free users to
> share our connexion database (we have only 1 database). We have 3
> different applications which share the same connection to our
> Interbase Database.

If you are talking about user licences. Then in IB 4.2, it was a 3
user licence for 3 connections. In IB 5.x, it was 4. In Borland's
commercial IB 6.x and 7.x, it is 1 user licence. If you need more
connections, you need to buy more user licences.

> So my questions are :
> I heard that with IB 7.0 (and since the version 6.0), it is possible
> to share a database connection between many different applications.

With IB 7.0 Borland states that the client library is thread safe, so
you wouldn't require to create a new connection for each thread(not
the same as an application). This is not the case for IB 6.x.

> Is it really possible with Firebird and how it works ?

It's not possible to share one connection with other applications, but
there's no limit to the number of connections to the Firebird server.
At the moment to my knowledge, the client library is not thread safe,
so you would require to create a new connection for each thread.

> Is it for this reason the IB4.2 free users have been deleted in next
versions ?

Probably Borland wanted a way to create some additional revenu compared
to previous versions.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)