agustianhans
Newcomer
- Joined
- Dec 30, 2004
- Messages
- 1
hi...
I used xml as datasource for my report (Crystal Report 10).
And i produce the xml file from a dataset with writexml method.
I got my dataset from asp.net webservice.
In my asp.net webservice application,
i executed Store Procedure in SQL 2000 Database Server to produce a dataset .
Sometimes the executed Store Procedure take a long time (2 minutes) to produce a dataset.
This dataset will be sent to my windows application and will be used to produce xml files.
This is my problem:
If ASP.Net WebService want to produce a record with a large amount (about 3000) data
with executed Store Procedure, it often failed
with error message "Server not responding" or "Can't perform transaction,because elapse transactions"
However, If i restart the server that hosted the asp.net webservice,
the asp.net webservice will only properly once, after that, the same problem will reoccure.
I had spent lots of time to solve this problem. I am giving up, any advice???? Pleaseeeeeee
I used xml as datasource for my report (Crystal Report 10).
And i produce the xml file from a dataset with writexml method.
I got my dataset from asp.net webservice.
In my asp.net webservice application,
i executed Store Procedure in SQL 2000 Database Server to produce a dataset .
Sometimes the executed Store Procedure take a long time (2 minutes) to produce a dataset.
This dataset will be sent to my windows application and will be used to produce xml files.
This is my problem:
If ASP.Net WebService want to produce a record with a large amount (about 3000) data
with executed Store Procedure, it often failed
with error message "Server not responding" or "Can't perform transaction,because elapse transactions"
However, If i restart the server that hosted the asp.net webservice,
the asp.net webservice will only properly once, after that, the same problem will reoccure.
I had spent lots of time to solve this problem. I am giving up, any advice???? Pleaseeeeeee