Re: opearation has timed out error

Timeouts usually happen due to record/table being locked...
You need to check with SQL Manager what and why something is locked...

From my experience if you link MS SQL table from MS Access that might put a
lock on a table when linked table is opened in Access.

My adocommandtimeout property is set to 0
PS: Not sure why you using ADO..., Actually waht database are you using? MS
SQL?

George.


"AVL" <AVL@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E7434E73-A1D7-442F-8D1A-5F2A5CED04DA@xxxxxxxxxxxxxxxx
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


.

Relevant Pages

  • Re: TIMEOUT ERROR & Connection String Property
    ... >> Is there anyway of setting the connection timeout property from the ... > I believe that only Timeout is what you want. ... > keyword in the connection string is the same as the name for the ... > Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se ...
    (microsoft.public.data.oledb)
  • Re: Check Linked Table Connection
    ... That will only test to make sure the connection is available. ... Run the query with a 20 second timeout. ... but I don't have any direct access to their SQL Server nor their ... I am an outside programmer that end-users contract, ...
    (comp.databases.ms-access)
  • Re: Timeout Expired
    ... So the timeout occurs during the bulk load operations? ... did you check the SQL Error Logs to see more clues about the timeout problem if there is any? ... locked for DML operations by SQL Server. ...
    (microsoft.public.sqlserver.server)
  • Re: Increase Connection Command timeout globally
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... in Stored procs which is causing it to timeout. ... Connection and Command timeout settings are done on the client. ... I expect you'll have to visit each Command object declaration and set the ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SQL Timeout Errors - Can Anyone Help?
    ... The timeout period elapsed prior to completion of the ... SQL Server does not time out. ... and you get further blocking and timeout. ... There are two possible reasons why a query takes more than 30 seconds ...
    (comp.databases.ms-sqlserver)
Loading