Tags: connectioncheckfordata, error, following, google, groups, microsoftodbc, missed, network, procedure, programming, running, server, sql, stored
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
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.
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.
Leave a comment...
- 0 Comments