I had that problem last year. I solved my problem by setting the CommandTimeOut of all my Command objects and I have added Pooling=False in my connection string.


>Hello there,
>
>From a VB.NET program that generates CSV-files from a SQL2000-database, I get the following error:
>
>13-4-2006 9:03:03
> CORE_DAL_OPERATION_FAILED
> at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, TdsParserState state)
> at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, TdsParserState state)
> at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
> at System.Data.SqlClient.TdsParser.ReadNetlib(Int32 bytesExpected)
> at System.Data.SqlClient.TdsParser.ReadBuffer()
> at System.Data.SqlClient.TdsParser.ReadByte()
> at System.Data.SqlClient.TdsParser.GetTokenLength(Byte token)
> at System.Data.SqlClient.TdsParser.ProcessColumnHeader(_SqlMetaData col, Boolean& isNull)
> at System.Data.SqlClient.TdsParser.ProcessRow(_SqlMetaData[] columns, Object[] buffer, Int32[] map, Boolean useSQLTypes)
> at System.Data.SqlClient.SqlDataReader.PrepareRecord(Int32 i)
> at System.Data.SqlClient.SqlDataReader.GetValue(Int32 i)
> at System.Data.SqlClient.SqlDataReader.get_Item(String name)
> at PinkRoccade.HSB.BusinessLogic.PersonMgr.ExecuteGetReportWorkLoad(DBConnection oConn)
> at CoreServices.DAL.TransactionManager.Run(Boolean fIsTransaction, DBOperation[] fDBOperations)
>
>*** General network error. Check your network documentation. ---
>
> at CoreServices.DAL.TransactionManager.Run(Boolean fIsTransaction, DBOperation[] fDBOperations)
> at PinkRoccade.HSB.BusinessLogic.PersonMgr.GetReportWorkLoad(String Location, DateTime EndDtFrom, DateTime EndDtTo, Int16 Region)
> at PinkRoccade.HSB.Physical.PBPersonMgr.GetReportWorkLoad(String Location, DateTime EndDtFrom, DateTime EndDtTo, Int16 Region)
> at PinkRoccade.HSB.Report.R1R2Report.GenerateR1ForRegion(Int16 iRegion)
> at PinkRoccade.HSB.Report.R1R2Report.CreateWorkvoorraadReport()
> at PinkRoccade.HSB.Report.ModReport.main()
>
>The error occurs totally unpredictable (it can occur every run for 15 runs and then 15 runs can work OK?!?!) and I can't explain the reason it occurs.
>
>Does anyone here have a clue??
>
>Greetings...