RE: operation has timed out error

Tech-Archive recommends: Fix windows errors by optimizing your registry



It sounds as if you are unsure if the timeout is between the client app <-->
web service, or the web service <--> SQL database. From the client machine,
can you connect to the web service with internet explorer? If so, then work
on the connection between the webservice and database. If you fail with IE
to the web service, there should be a clue in the error message.

"AVL" wrote:

Hi,
I'm working on a windows application. My app uses web service to connect
to the sql server db. The app and web service are running fine on my
development environment but
whe deployed on to production server, i'm receving the
'operation has timed error'.

I've tried all the possible solutions given on the net like setting timeout,
configuring the executionTImeout etc.. but no luck..

My adocommandtimeout property is set to 0
connection timeout property is set to 60

Can someone help me out in figuring out this issue?

.



Relevant Pages

  • Re: One Web Service updates SQL, another cant?
    ... Columnist, SQL Server Professional ... I guess its because this is my first Web Service and I ... it opens the database connection. ... See what that gives you in the trace. ...
    (microsoft.public.sqlserver.security)
  • Re: One Web Service updates SQL, another cant?
    ... > ' returns no Recordset ... > Columnist, SQL Server Professional ... it opens the database connection. ... >> Web Service is running. ...
    (microsoft.public.sqlserver.security)
  • Re: One Web Service updates SQL, another cant?
    ... > ' returns no Recordset ... > Columnist, SQL Server Professional ... it opens the database connection. ... >> Web Service is running. ...
    (microsoft.public.sqlserver.security)
  • Re: One Web Service updates SQL, another cant?
    ... > Columnist, SQL Server Professional ... I guess its because this is my first Web Service and I ... it opens the database connection. ... >> In the profiler, in the Events tab, click on Security Audit. ...
    (microsoft.public.sqlserver.security)
  • Re: Web Services and SQL Server Stored Procedures
    ... but don't require the consumer to do anything but consume the web service. ... feel compelled to leave the connection open for the entire lifespan of the ... the next sql statement, it probably needs closed. ... "Christopher Rose" wrote in message ...
    (microsoft.public.dotnet.framework.adonet)