|
Home > Archive > MS SQL Server Notification Services > March 2006 > stored procedure Timeout problem.
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
stored procedure Timeout problem.
|
|
| vineet.jsl@gmail.com 2006-02-28, 8:30 pm |
| Hello EveryBody..
First i want to thanx all of you who for sharing knowledge.
And personally i think that if there were no Google kinda thing, then
developer's life might be very hard. Google provide us a place for
things get done. Google Really makes our life easy.
Now i want to come on my query.
i made a stored procedure which used SP_OA..... procedures for
accessing a http based URL.
let me clear the scene..
i made a procedure which creates a Microsoft.XMLHttp object then with
this object i access a URL which recieves a the request and immediately
process that request and send back the response.
now here i am facing problems with timeout.
there is a situation when my procedure sends a request but didn't get
the response back, but at server end that transaction is showing
successfull. but at client end the response had not been recieved.
so the main problem is here that i dont have any transaction record
for those cases.
can somebody gimme any solution on these type if problems
Regards,
Vineet
| |
|
| Try using asynchronous way of submitting your request to http with timeout
// async call
xmlhttp.Open("POST", url, true);
// callback for the call
xmlhttp.onreadystatechange =
function ()
{
if (xmlhttp.readyState == 4)
{
var response = xmlhttp.responseText;
}
}
<vineet.jsl@gmail.com> wrote in message
news:1141109166.025799.242760@i40g2000cwc.googlegroups.com...
> Hello EveryBody..
>
> First i want to thanx all of you who for sharing knowledge.
> And personally i think that if there were no Google kinda thing, then
> developer's life might be very hard. Google provide us a place for
> things get done. Google Really makes our life easy.
>
> Now i want to come on my query.
>
> i made a stored procedure which used SP_OA..... procedures for
> accessing a http based URL.
> let me clear the scene..
> i made a procedure which creates a Microsoft.XMLHttp object then with
> this object i access a URL which recieves a the request and immediately
> process that request and send back the response.
>
> now here i am facing problems with timeout.
>
> there is a situation when my procedure sends a request but didn't get
> the response back, but at server end that transaction is showing
> successfull. but at client end the response had not been recieved.
> so the main problem is here that i dont have any transaction record
> for those cases.
>
> can somebody gimme any solution on these type if problems
>
> Regards,
> Vineet
>
|
|
|
|
|