Board index » delphi » IIS->ISAPI->Delphi DLL->BDE->Paradox

IIS->ISAPI->Delphi DLL->BDE->Paradox

Hello All,

We are running Microsoft IIS and launching ISAPI DLLs written in Delphi
2.01  When multiple instances of our DLLs try to access the same databases
(this happens when different people post to the same ISAPI DLL on our
website at the same time) we get Access Violation errors.  It looks to us
like the BDE is not able to handle simultaneous requests access from
multiple instances of our DLLs.  

BTW, we are using TQuery.SQL, Paradox 7, and BDE 3.12 and 3.5.

Any suggestions would be appreciated.

Thanks,

Miles Porter.

Miles R. Porter
Director of Technology
RIT Systems

 

Re:IIS->ISAPI->Delphi DLL->BDE->Paradox


Quote
mporter wrote:

> Hello All,

> We are running Microsoft IIS and launching ISAPI DLLs written in Delphi
> 2.01  When multiple instances of our DLLs try to access the same databases
> (this happens when different people post to the same ISAPI DLL on our
> website at the same time) we get Access Violation errors.  It looks to us
> like the BDE is not able to handle simultaneous requests access from
> multiple instances of our DLLs.

> BTW, we are using TQuery.SQL, Paradox 7, and BDE 3.12 and 3.5.

> Any suggestions would be appreciated.

> Thanks,

> Miles Porter.

> Miles R. Porter
> Director of Technology
> RIT Systems

Try using WebHub by Href.  It is a great product and well worth the
money. Check it out at www.href.com

Re:IIS->ISAPI->Delphi DLL->BDE->Paradox


Quote
mporter wrote:

> Hello All,

> We are running Microsoft IIS and launching ISAPI DLLs written in Delphi
> 2.01  When multiple instances of our DLLs try to access the same databases
> (this happens when different people post to the same ISAPI DLL on our
> website at the same time) we get Access Violation errors.  It looks to us
> like the BDE is not able to handle simultaneous requests access from
> multiple instances of our DLLs.

> BTW, we are using TQuery.SQL, Paradox 7, and BDE 3.12 and 3.5.

> Any suggestions would be appreciated.

> Thanks,

> Miles Porter.

> Miles R. Porter
> Director of Technology
> RIT Systems

Try WebHub by Href.  It is well worth the money and will save you lots
of time.  Check it out at www.href.com

Re:IIS->ISAPI->Delphi DLL->BDE->Paradox


You need to make sure in each time through the DLL, you create a new
TSession with a NEW, ORIGINAL name.  Use the thread id for the name of the
TSession (SessionName).  Connect any other database components to that
session.  That should handle it, unless its a shortcoming of Paradox, but
we had the same problem using Delphi 2, IIS, and Sybase SQL Server 11, and
thats the fix I used.  Let me know how you make out!

jhan...@ihsp.net

Re:IIS->ISAPI->Delphi DLL->BDE->Paradox


We create our own ISAPI stuff, and since the BDE only handles 32
connections, (I think), we have to use our own Mutexing to gain High volume
access. Also I should say that it is using FoxPro tables no paradox but the
multithreaded issues are the same......

Gordon
Voice Data Systems Inc.
360-686-8315

Todd V. Rovito <todd.rov...@{*word*104}gate-comm.com> wrote in article
<332B06C6.4...@{*word*104}gate-comm.com>...

Quote
> mporter wrote:

> > Hello All,

> > We are running Microsoft IIS and launching ISAPI DLLs written in Delphi
> > 2.01  When multiple instances of our DLLs try to access the same
databases
> > (this happens when different people post to the same ISAPI DLL on our
> > website at the same time) we get Access Violation errors.  It looks to
us
> > like the BDE is not able to handle simultaneous requests access from
> > multiple instances of our DLLs.

> > BTW, we are using TQuery.SQL, Paradox 7, and BDE 3.12 and 3.5.

> > Any suggestions would be appreciated.

> > Thanks,

> > Miles Porter.

> > Miles R. Porter
> > Director of Technology
> > RIT Systems
> Try using WebHub by Href.  It is a great product and well worth the
> money. Check it out at www.href.com

Re:IIS->ISAPI->Delphi DLL->BDE->Paradox


Quote
"mporter" <mpor...@ritsystems.com> wrote:
>Hello All,
>We are running Microsoft IIS and launching ISAPI DLLs written in Delphi
>2.01  When multiple instances of our DLLs try to access the same databases
>(this happens when different people post to the same ISAPI DLL on our
>website at the same time) we get Access Violation errors.  It looks to us
>like the BDE is not able to handle simultaneous requests access from
>multiple instances of our DLLs.  
>BTW, we are using TQuery.SQL, Paradox 7, and BDE 3.12 and 3.5.
>Any suggestions would be appreciated.
>Thanks,
>Miles Porter.
>Miles R. Porter
>Director of Technology
>RIT Systems

I know that there is a limitation in Delphi16/BDE2.52 where you can
only have one DLL at a time that uses the BDE.

Re:IIS->ISAPI->Delphi DLL->BDE->Paradox


FYI,

Thanks to everyone who responded.  The solution was to use unique session
names on the TTable and TQuery objects.  (See Joe's reply.)

Thanks,

Miles Porter
Director of Technology
RIT Systems
Creators of Jobkeys  http://www.jobkeys.com/

mporter <mpor...@ritsystems.com> wrote in article
<01bc2ffb$7b5e5dd0$bbf891ce@colorado>...

Quote
> Hello All,

> We are running Microsoft IIS and launching ISAPI DLLs written in Delphi
> 2.01  When multiple instances of our DLLs try to access the same
databases
> (this happens when different people post to the same ISAPI DLL on our
> website at the same time) we get Access Violation errors.  It looks to us
> like the BDE is not able to handle simultaneous requests access from
> multiple instances of our DLLs.  

> BTW, we are using TQuery.SQL, Paradox 7, and BDE 3.12 and 3.5.

> Any suggestions would be appreciated.

> Thanks,

> Miles Porter.

> Miles R. Porter
> Director of Technology
> RIT Systems

Other Threads