Hi everybody,
We have built a 3 tier application in which asp is front end and backend is oracle and vfp is in middle since the application is used on WAN. The main problem comes in when too many users fire the same report, the mtx hangs and then unless you end task the mtx you can't proceed further.
When a user request a report, the dll fetches data from the server, manipulates it and creates a report file and the dll then passes on the filename to the front end which then zips up the same and transfer to client side. A sample prg is given below

lcInitstring1="Chr(27)+'@'"
lcInitstring2="Chr(27)+Chr(67)+Chr(72)"
lcPageeject="Chr(12)"

lcAltfile=tcOutputfile
Set Alternate to &lcAltfile
Set Alternate On
Set Cons Off
?? &lcInitstring1
?? &lcInitstring2
lnPgbreak=64
Scan
?
??
Endscan
Set Console On
Close Alternate
Set Alternate Off

retu

Can anyone tell me what could be the problem

Regards and Thanks.

Bhavesh Desai