Make sure you're using the .VFP. Session class for the mtdll. Also, the mtdll should be multi-use for Instancing. Your error handler should have the COMRETURNERROR command to gracefully end from any kind of error. Where is the "REPORT FORM" located? I'm assuming it's in a .EXE. I've had the best results with this by putting the "REPORT FORM" in a COM .EXE, not a regular .EXE, and calling it from the mtdll. Or is Oracle generating the report?..
>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