Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
monty
Posting Yak Master
130 Posts |
 Posted - 2006-11-01 : 20:29:20
|
| There is an issue iam trying to resolve regarding a webservice we are running on stage and production which accesses a database. The webservice basically involves a SOAP http request and response. This request works sometimes but most of the time it fails when accessed from within a client as a separate thread.It returns a status code of 503 which can mean a number of things. One can be if the dB connection was either broken or no connection was available for the pool used. In this case it will just return a 503. The server logs do not give any error messages so I checked this from the database end to narrow down the reason for this failure. I am looking for some help with regards to any connection pool set up. Is there a way to know if a dB connection was not serviced for any reason?and how can we avoid broken connections between the Application server and the dB? If dB pooling is set up shouldn't it provide a connection? its me monty |
|
|
|
|
|
Connection Error