hi guys
i'm developing a multi-tier web application which at a given point calls a stored procedure that returns data formated as XML ( 'select .... for xml auto' basically).
That SP returns a list of tasks allocated to 1 or more resources.
The problem is that from time to time (and that is totally random, anything from 30seconds to 10mins) whenever the code calls that SP, the XML structure isn't there, so no data is listed.
Question is: is this a problem within SQL Server XML support or anything related to .NET?
I'm using .NET 2.0.50727 with VS2005 8.0.50727.42, and SQL Server 2005 and IE 6.0.2900
Also, if i refresh the browser and go to the Task listing page, the list comes back again!
Note that i'm NOT using SESSIONs in ANY point, so this has nothing to do with sessions.
TIA
Sérgio Charrua
www.pdmfc.com
Portugal
Hi Sergio,
SQL Server XML support is very useful for some issues. But It isn't scalable solution.
Good Coding!
Javier Luna
http://guydotnetxmlwebservices.blogspot.com/
|||It's diffcult to figure out what's causing the problem. From SQL side, if a SP returns XML data, it just returns a binary stream to the client as other returned data. I suggest you open SQL Profiler to trace the SQL Server when the prolbem repros, so that you can clarify whehter SQL returns expected result set or empty (none) result, or maybe some network issue.sql
No comments:
Post a Comment