opearation has timed out error

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

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" wrote in message
news:E7434E73-A1D7-442F-8D1A-5F2A5CED04DA@microsoft.com...
> 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