How to resolve "General Network Error"?

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?

GaryF
Sat Dec 04 18:43:01 CST 2004

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?

"Gary F" wrote:

> 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?
>

GaryF
Sat Dec 04 20:41:01 CST 2004

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?

"Gary F" wrote:

> 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?
>
> "Gary F" wrote:
>
> > 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?
> >