General Network Error when CommandTimeout insufficient for Sq

[Yong]

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.