Subject Re: [ib-support] Share a database connexion
Author Cédric JOUBERT
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)


Yahoo! Groups Sponsor



To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.