Hi

My understanding is that FB does not support multiple threads on one connection, i.e. the fbClient.dll library was not thread safe.  The work around for this is to simply create a new connection, within the new thread.  This is what my suggestion is.  My understanding is FB 3 will support multiple threads on a single DB connection.

Here is how I usually do it to get you started.   p.s. this is just an example not real code...


Put all IBO component creation / releasing code within the .execute procedure of the thread.  I often pass connection details into the threads constructor method  (fConnecionDetail has this detail).

sample TThread.execute method....


        Session                       := TIB_Session.Create(Nil);
        Session.UseCursor     := False;

        IBODataBase := TIBODatabase.Create(Session);
        IBODataBase.IB_Session      := Session;
        IBODataBase.Path                 := fConnecionDetail.DBPath;
        IBODataBase.SchemaCacheDir  := fConnecionDetail.SchemaCacheDir
        IBODataBase.Server          := fConnecionDetail.Server;
        IBODataBase.Password        := fConnecionDetail.Server;
        IBODataBase.Username        := fConnecionDetail.UserName;
        IBODataBase.Protocol        := cpTCP_IP;
        IBODataBase.Connected       := True;

    Transaction            := TIB_Transaction.CreateForSession(fIBODataBase, fIBODataBase.IB_Session);
    Transaction.Isolation  := tiCommitted;
    Transaction.AutoCommit := False;

        aQuery := TIBOQuery.Create(Session);
        aQuery.IB_Session := Session;
        aQuery.ib_Connecion := IBODatabase;
       aQuery.IB_Transaction := Transaction;
       try
.....
     finally
     


     end


Cheers
Rob

On 9/06/2014 5:03 p.m., russell@... [IBObjects] wrote: