[DUG] Question

[Debdarsan Niyogi]

Hi, 
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...
 
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. 

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...
 
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?
Many thanks! 

Dr Debdarsan Niyogi
Tata Consultancy Services
Plot C, Block EP ,
Salt Lake Electronics Complex
Kolkata - 700091,West Bengal
India
Mailto: debdarsan.niyogi at tcs.com
Website: http://www.tcs.com
____________________________________________
Experience certainty. IT Services
   Business Solutions
   Outsourcing
____________________________________________
=====-----=====-----=====
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


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.adventureeducation.co.nz/pipermail/delphi/attachments/20070810/800ab8f7/attachment.html