Hi,

Correctly Daniel.

I use n-tier architecture to share a database connection.

Example: thin-client <---> business object <----> data object <--->
database

business object -> It has the logic of application.
data object -> It execute the database connection and statement SQL
requested by business object.

They are objects COM installed at Microsoft Apllication Server ( COM+ ).

Regards,
Marcelo

> ----- Mensagem original -----
> De: Daniel Rail [SMTP:daniel@...]
> Enviada em: sexta-feira, 25 de abril de 2003 09:30
> Para: ib-support@yahoogroups.com
> Assunto: Re: [ib-support] Share a database connexion
>
> Hi,
>
> At April 25, 2003, 07:32, Cédric JOUBERT wrote:
>
> > 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.
>
> First, Borland sees 1 user as the same as 1 database connection. Each
> application will have to have it's own connection. There might be a
> possibility to have more than one application using only one
> connection, and that would be to develop a middle-tier server for
> connection pooling, which would be your database connection. And, your
> application connects to the middle-tier.
>
> Just to let you know that I use Firebird for the applications that I
> create and maintain for my clients.
>
> --
> Best regards,
> Daniel Rail
> Senior System Engineer
> ACCRA Group Inc. (www.accra.ca)
> ACCRA Med Software Inc. (www.filopto.com)
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>