Hi Helen,

Yes, this aproach is the better, but, i can do this using embedded server ?
I will have a lot of simultaneous connections on embedded server...

Thanks,

Gustavo.

----- Original Message -----
From: Helen Borrie
To: firebird-support@yahoogroups.com
Sent: Saturday, July 29, 2006 1:10 PM
Subject: Re: [firebird-support] Embedded server


At 02:04 AM 30/07/2006, you wrote:
>Hi All,
>
>Is firebird embedded thread safe ?
>
>May i run some jobs in a separate thread and
>this threads query (select, insert, update) the embedded server ?
>I´m using Delphi 7 and Zeos library to connect.
>I will create the query in runtime and will
>share the same connection component.

No, you can't do this (share a connection across
threads). Define a datamodule containing
everything that will be used by a thread instance
- including a connection - and create (and
afterwards destroy) an instance of this datamodule for each thread instance.

./heLen





[Non-text portions of this message have been removed]