microsoft.public.sqlserver.server - HELP ! ConnectionCheckForData Timeout expired error

Author

HELP ! ConnectionCheckForData Timeout expired error

Nicky

2002-08-05, 8:23 am

I have the following error message when calling my db with
a procedure from some c# code -
"Timeout expired. The timeout period elapsed prior to
completion of the operation or the server is not
responding"

The error does not occur if I run the procedure from Qurey
Analyzer. - I have changed the configuration in my sql
server to allow unlimited time when running a query but
that has made no difference.

Any help would be most appreciated.

Cheers
Nicky

[MS] Eric Yang

2002-08-06, 9:23 pm

Dear Nicky,

There is a CommandTimeout property in the SqlCommand. It means the time (in
seconds) to wait for the command to execute. The default is 30 seconds.
Please increase the value of this property. You can also explicitly setting
the CommandTimeout to 0 to test. (A value of 0 indicates no time limit)
The following is an example. 'sp_delay' indicates the store procedure which
needs to be executed.

m_da.SelectCommand.CommandTimeout=0;
m_da.SelectCommand.CommandType=CommandType.StoredProcedure;
m_da.SelectCommand.CommandText="sp_delay";
m_da.Fill(m_ds, "Products");

Sincerely,

Eric Yang [MS]
Microsoft Online Support Engineer

Please do not send email directly to this alias. This is our online
account name for newsgroup participation only.
This posting is provided 'AS IS' with no warranties, and confers no rights.
Get Secure! - www.microsoft.com/security

Sponsored Links