Home > Archive > MS SQL Server Connectivity > February 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:24 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

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com