Getting SQL Error - "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?

Miha
Sun Dec 05 00:34:29 CST 2004

Hi Gary,

Maybe you could use sqlprofiler to see the actual sql statements being
invoked.

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
SLODUG - Slovene Developer Users Group
www.rthand.com

"Gary F" <Gary F@discussions.microsoft.com> wrote in message
news:AED29A16-F447-4D92-91B6-2C2A1BC99375@microsoft.com...
> 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?
>