This is a most frustrating one. I have an application that executes a stored procedure in SQL to update a record (VB language, .Net framework 1.0 with SP, SQL provider, connecting using TCP/IP). As part of the update, a dataset is being saved as XML into one of the table fields - this is a text parameter. Now, this dataset size can vary from 0 bytes to a few megabytes. After applying SQL SP4, we've started getting a "General Network Error - check your network doc" error but only when the dataset to be stored is large (>32kb).
I've tried the following:
-Changing the packet size of the connection - no dice.
-Changing the server of the connection from a host name to an IP address - no luck.
-Installing the application in the same box as the SQL server and using (localhost) in the connection string - no joy.
-Disabled connection pooling - same results.
-Applied values from 0 to 30 to 999 to the timeout value of the command - nothing.
This behavior is only observed in a Win2K server box with lots of resources. Other Win2K pro/server boxes or WinXP boxes do not have the same problem - latest Win/SQL service packs/patches on all of them.
All parameters are of the correct SqlDBType and the direction is set correctly. Anyone has encountered this error before or has any idea about it? The net is filled with posts of pain about this GNE error but no two people seem to find identical solutions to this problem.
