Network Error: ConnectionCheckForData

If this is already in Google Groups, I missed it.

I was getting the following error when running a stored procedure:

[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionCheckForData

(CheckforData()).

Server: Msg 11, Level 16, State 1, Line 0

General network error. Check your network documentation.

Connection Broken

I'd never seen this caused just by running the wrong SQL statements.

Freaked me out. As I took the thing apart I finally got a message something

like "the query plan tried to put a text pointer in a bad place, it can only

put text pointers in blahblahblah".

Part of the select statement was against columns of type text. When I cast

these columns to varchars in the select, all the errors disappeared.

Just a heads up in case someone else is experiencing a similar problem.

Matt

http://sql.itags.org/q_sql_36553.html