Hi all - not sure if this is the proper forum for this post, since it kinda spans several different areas, but this was the closest fit I could find.
I have a set of CLR functions, written in C#, which invoke a web service call, and then return a value back based on the result of the query.
Recently, this CLR has been timing out on the database.
I've tested this to the limit of my knowledge, but could not locate the problem.
If I run the web service from my browser, it works - I get the response fine.
If I run the CLR straight from Visual Studio, it still works.
If I log on to the machine that the server is hosted on, and try the web service, it works.
From the server, if I run a very similar CLR, which accesses the same web service, but against a different website, it works.
So, my conclusion from all of this, is that it must have something to do with the communication between the server and the website. But I can't really continue any further, to try and figure out exactly what the problem is, and how to address it.
Any insight would be appreciated!