Error: ConnectionCheckForData (CheckforData())

[fredjonze]

Hi,

I'm running SQL 2k SP3a on a 2.2P4 workstation with 250GB drives and Windows Server 2003 sp1. I'm running a fairly simple stored proc and I get the following error:

[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionCheckForData (CheckforData()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.

Connection Broken

I've tried changing protocols in the client utiltiy (tcp and named pipes) as suggested elsewhere. There are no errors in the application log or the sql log.

Any ideas what is happening? The same query doesn't crash on W2k Server/SQL Server 2k. It happens repeatedly, but sometimes on the first, second or third execution of the stored proc.

Thanks for any insight.

 

[JayKusch]

Hmmm ... Picking at straws here ...

Add this as your first line of the query and re-run it

SET NOCOUNT ON

Did you recieve the error again?

Thanks

J. Kusch