By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,083 Members | 1,608 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,083 IT Pros & Developers. It's quick & easy.

General Network Error when CommandTimeout insufficient for Sq

P: n/a
I'm not getting any reply to my previous thread so I'm stating a new one.

I get a General Network Error due to my SqlCommand object not having a big
enough CommandTimeout to complete very long sql statements. My question is
this: Why does SQL generate a General Network Error instead of the Timeout
Expired Error? When I run my program multiple times, there are cases where
I'd get the Timeout Expired Error ("The timeout period elapsed prior to
completion of the operation or the server is not responding"), but most of
the time, it would generate the General Network Error. What exactly is
causing this General Network Error? What exactly is happening when the
SqlCommand runs out of time and cannot complete the sql statement? It seems
to me that it should always generate the timeout expired error instead of the
general network error since the issue causing the error was the
CommandTimeout property being too small.

Feb 14 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.