How to resolve "General Network Error"?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm getting the following message trying to update a SQL Server table:
"General network error. Check your network documentation."

I'm using stored procedures via a SQL data connection from within a .Net
windows application. The application producing the error, reads a table from
the server, then proforms a series of updates, deletions and insertions
locally to a DataSet. After all processing is completed, the data is written
back to the server using the Update(dataset, "table_name") method on the
DataAdapter. The Update method is called 3 times, once for all updated rows,
once for all inserted rows and once for all deleted rows.

Currently, I read and update 3 tables in seperate datasets. 2 tables work
and the 3rd does not. How can I get resolved this issue?
 
After read more posting about this issue, I decided to use the RowUpdated and
RowUpdating events to determine what is happening. It appears that the
connection is being Closed after the 14th row is updated. This happens on
the same row every time and even if I remove all the rows from the sql table.
Why is the connection being closed?
 
I have determined that 24 rows of about 2000 rows is causing this issue. I
have got around the issue by simply reopening the connection and changing the
UpdateStatus to Continue. Thus, all data rows except the 24 are now posted.
I still don't know what is causing the connection to close for these 24 rows.
Any ideas what I should be looking for?
 
Back
Top