Internal connection fatal error.

[TexasAggie]

I am writing parameterized data to SQL at 1Hz from several test cell computers (maximum 16, currently running 5 or less). The code works fine though I was losing connection sometimes when using SQL Developer edition. We installed the full SQL server last week and all was well until I got the following error this morning.

 

What would cause this error?

Should I leave the connection open to avoid extra overhead in opening and closing it every second?

How should I recover from this error? Close the connection, reopen, and retry?

 

10:55:21 FlightRecorder

System.InvalidOperationException: Internal connection fatal error.

at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)

at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)

at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)

at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

at DEER_DAQ.modFunctions.BuildSQLDataString()

 

Thanks.