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_SQLBuffer, (SqlConnection)
m_connection);
sqlCommand.CommandTimeout=0;
//I GET THE EXCEPTION ON THE LINE BELOW
m_numOfRowAffected = sqlCommand.ExecuteNonQuery();
//
//Throws an exception of System.SystemException {"General
network error. Check your network documentation."}

Does anyone know what this exception means?

Thanks

[Morten Wennevik]

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]

Hello,

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

Thanks,

-----Original Message-----
Connecting to the sql server fails for some odd reason? Maybe it getsbroken mid query or something.
Sorry, can't really help. Use a try/catch statement to get a moredescriptive error message.

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

[Morten Wennevik]

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]

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" <an*******@discussions.microsoft.com> wrote in message
news:0f****************************@phx.gbl...

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_SQLBuffer, (SqlConnection)
m_connection);
sqlCommand.CommandTimeout=0;
//I GET THE EXCEPTION ON THE LINE BELOW
m_numOfRowAffected = sqlCommand.ExecuteNonQuery();
//
//Throws an exception of System.SystemException {"General
network error. Check your network documentation."}

Does anyone know what this exception means?

Thanks

[Buddy]

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

Thanks,

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

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