General network error. Check your network documentation.

[Buddy]

Hello,

I'm getting the following error when running a large SQL.
I am using the SqlCommand and calling the ExecuteNonQuery
with the CommandTimeout set to 0.

Here is the example of the code

sqlCommand = new SqlCommand(m_SQ LBuffer, (SqlConnection)
m_connection);
sqlCommand.Comm andTimeout=0;
//I GET THE EXCEPTION ON THE LINE BELOW
m_numOfRowAffec ted = sqlCommand.Exec uteNonQuery();
//
//Throws an exception of System.SystemEx ception {"General
network error. Check your network documentation." }

Does anyone know what this exception means?

Thanks

[Morten Wennevik]

Re: General network error. Check your network documentation.

Connecting to the sql server fails for some odd reason? Maybe it gets
broken mid query or something.
Sorry, can't really help. Use a try/catch statement to get a more
descriptive error message.

--
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/

[Buddy]

Re: General network error. Check your network documentation.

Hello,

There are'nt any broken queries and I have used the
try/catch which provided the error information.

Thanks,
[color=blue]
>-----Original Message-----
>Connecting to the sql server fails for some odd reason?[/color]
Maybe it gets[color=blue]
>broken mid query or something.
>Sorry, can't really help. Use a try/catch statement to[/color]
get a more[color=blue]
>descriptive error message.
>
>--
>Using M2, Opera's revolutionary e-mail client:[/color]
http://www.opera.com/m2/[color=blue]
>.
>[/color]

[Morten Wennevik]

Re: General network error. Check your network documentation.

Can you execute any other query to the database?
I get a feeling that while ExecuteNonQuery is waiting for the result it
looses touch with the server.

--
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/

[José Joye]

Re: General network error. Check your network documentation.

Could you have a look in the directory where SQL Server places its logs.
Last time I had such an error, it was due to a real crash of MSSQL and I had
a SQL dump in it.

José
"Buddy" <anonymous@disc ussions.microso ft.com> wrote in message
news:0f2901c3a9 08$afdc9fd0$a10 1280a@phx.gbl.. .[color=blue]
> Hello,
>
> I'm getting the following error when running a large SQL.
> I am using the SqlCommand and calling the ExecuteNonQuery
> with the CommandTimeout set to 0.
>
> Here is the example of the code
>
> sqlCommand = new SqlCommand(m_SQ LBuffer, (SqlConnection)
> m_connection);
> sqlCommand.Comm andTimeout=0;
> //I GET THE EXCEPTION ON THE LINE BELOW
> m_numOfRowAffec ted = sqlCommand.Exec uteNonQuery();
> //
> //Throws an exception of System.SystemEx ception {"General
> network error. Check your network documentation." }
>
> Does anyone know what this exception means?
>
> Thanks[/color]

[Buddy]

Re: General network error. Check your network documentation.

I can execute other queries but when I try and excecute
queries that takes at least 5 minutes I get the exception.

Thanks,[color=blue]
>-----Original Message-----
>Can you execute any other query to the database?
>I get a feeling that while ExecuteNonQuery is waiting for[/color]
the result it[color=blue]
>looses touch with the server.
>
>--
>Using M2, Opera's revolutionary e-mail client:[/color]
http://www.opera.com/m2/[color=blue]
>.
>[/color]