Re: Confusing error message
- From: "Daniel" <DanielV@xxxxxxxxxxxxxxxx>
- Date: Fri, 22 Sep 2006 20:04:50 +0100
looks like your sql statement has a problem in it. Debug and stop when the
sql is about to execute. Take the sql statement and put it in Query Analyser
and run it direct, see if it works. If it does you can scrub the sql
statement as a possible issue, but i think you'll find your sql statement
throws an error ;)
"John J. Hughes II" <no@xxxxxxxxxxx> wrote in message
news:OO$6lkn3GHA.476@xxxxxxxxxxxxxxxxxxxxxxx
I have a SqlDataAdapter.Fill filling a standard dataset and my code is
returning the below error. The "Error Loading data" is just a message my
code displays. "Error:" is the Exception.Message message and then below
that is the stack trace. The strange part is the "Error:" data is data
from the SQL database and obviously not an error so I don't see how or why
it is there. Any clues for determining why the code is throwing an
expection from this would be helpful.
Note being a little short sighted I don't trap the SqlException just the
Exception but normally that is more meaningful then this.
Error Loading data
Error:
71:
RP:09603ppppppppX!8op%&6#3'ppppppppX+pppppppp$)!pppp%&<])pppppppp\pppp
Stack:
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.HasMoreRows()
at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout)
at System.Data.SqlClient.SqlDataReader.Read()
at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)
at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset,
DataTable datatable, String srcTable, DataReaderContainer dataReader,
Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn,
Object parentChapterValue)
at System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable,
IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset,
DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String
srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
at Utils.dbFunc.LoadData(Form frm, SqlConnection cn, SqlDataAdapter ad,
DataSet ds, String msg)
.
- Follow-Ups:
- Re: Confusing error message
- From: John J. Hughes II
- Re: Confusing error message
- References:
- Confusing error message
- From: John J. Hughes II
- Confusing error message
- Prev by Date: Re: firefox download process
- Next by Date: Paradigm for multiple IDisposables
- Previous by thread: Confusing error message
- Next by thread: Re: Confusing error message
- Index(es):
Relevant Pages
|
