Multiple DB Connections with ISAPI DLLs

Trying my hardest to provide the ability to connect to varying databases through the BDE within an ISAPI DLL.

Problem im having is that once connected through the browser in one request then I attempt to run SQL operations with following requests, I lose connection to that DB because another browser using another thread has taken that connection up.

I know it is a question of synchronising threads but does anyone know a way round this????

Have you included a TSession component on your
datamodule and set AutoSessionName to True?

See the TI on the Borland community site for more
info on using BDE and ISAPI...

The problem I have there in one attempt is that I have a TSession and I have two database components. Now I know that a database requires its own session on a form so i dynamically create the second lot of sessions with no owner which gets round the AutoSessionName problem. But still I can't seem to sync the databases with the right request???????

Do u think using the session name would help me sync up the request to the right Database Session, thread whatever????

Why not have two session components?

Because you can only have one session on while Autosessionnames is set to true