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

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