Subject Re: [ib-support] Share a database connexion
Author Daniel Rail
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)