amilapradeep (8/14/2014)
I am experiencing the same issue right now.scenario is same as your. but if web service and SQl server are on same machine, then it works fine (so URL is localhost). if i tried to call remote web service (or website), then it works 2 times, JUST 2 TIMES. from third call, it starts to time out.
It starts to work again after i restarted sql server. (just 2 calls only)
Could you please help me to overcome this.
Hi there. Considering that it does work a couple of times and then stops, that leads me to think that it is a resource issue. Are you properly closing the HttpWebRequest and any other resources that have a Close() method? I would not rely on a using() statement to take care of it but instead make sure to have the Close() calls in a finally block.
Any File System and Network resources opened will become orphaned and remain open if not properly closed.
Take care,
Solomon..
SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
Info sites — Collations • Module Signing • SQLCLR