<br><font size=3>Hi,
</font>
<br><font size=3>I have written a web service using Delphi 2005, using
BDE and Oracle 9i as a backend database (running on Win XP). I have a TSOAPDataModule.
It is an ISAPI dll hosted on IIS 5.1. It is working fine with a single
call (i.e. it is retrieving and posting data to database) but for asynchronous
call it is throwing "Cannot perform this operation on a Open Database".
I tried to use TSession Component - with no result. I am not sure I am
using TSession correctly or not. Also, I'm open to any other suggestion.
I need it very badly. Gurus please help me out...</font>
<br><font size=3>
</font>
<br><font size=3>Could you please give me an example snippet of using TSession
for each asynchronous call? Do I create it at run time and what properties
do I have to set? I have a TDatabase component on the TSOAPDataModule.
Do I have to make a DB connection using TDatabase during design time? I
am producing an ISAPI DLL. <br>
</font>
<br><font size=3>It is too late to convert it to ADO - and I have to solve
this problem with at least 5 asynchronous calls for NOW. Later on, I might
have time to change it to ADO. Please provide a quick solution so that
I can provide a temporary solution by today - tall order? I'm really sorry.
Please help... with code snippets and instructions...</font>
<br><font size=3>
</font>
<br><font size=3>I forgot to add that at present I have a TSession component
on TSOAPDataModule, not creating any TSession at runtime, and trying to
see if it can handle more that one call, when the first processing is still
continuing (reading and writing Oracle database). Is it worth pursuing?<br>
Many thanks! </font>
<br><font size=2 face="sans-serif"><br>
Dr Debdarsan Niyogi<br>
Tata Consultancy Services<br>
Plot C, Block EP ,<br>
Salt Lake Electronics Complex<br>
Kolkata - 700091,West Bengal<br>
India<br>
Mailto: debdarsan.niyogi@tcs.com<br>
Website: http://www.tcs.com<br>
____________________________________________<br>
Experience certainty. IT Services<br>
Business Solutions<br>
Outsourcing<br>
____________________________________________</font><pre>=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain
confidential or privileged information. If you are
not the intended recipient, any dissemination, use,
review, distribution, printing or copying of the
information contained in this e-mail message
and/or attachments to it are strictly prohibited. If
you have received this communication in error,
please notify us by reply e-mail or telephone and
immediately and permanently delete the message
and any attachments. Thank you
</pre>