System.Data.OleDb.OleDbException: Unspecified error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a asp.net (framework 1.1) site interfacing against SQL 2000. It runs like a charm 99% of the time but once in a while I get the following "unspecified error". Sometimes it would resolve by itself (asp.net recycled?); it also can be solved by restarting IIS.

Any ideas what cause(s) this to happen?

System.Data.OleDb.OleDbException: Unspecified error
at System.Data.OleDb.OleDbDataReader.ProcessResults(Int32 hr)
at System.Data.OleDb.OleDbDataReader.GetRowHandles()
at System.Data.OleDb.OleDbDataReader.ReadRowset()
at System.Data.OleDb.OleDbDataReader.Read()
at System.Data.OleDb.OleDbDataReader.HasRowsRead()
at System.Data.OleDb.OleDbDataReader.NextResult()
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, 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, Int32 startRecord, Int32 maxRecords, String srcTable)
at DreamweaverCtrls.DataSet.DoInit()<hr>System.Data.OleDb.OleDbException: Unspecified error
at System.Data.OleDb.OleDbDataReader.ProcessResults(Int32 hr)
at System.Data.OleDb.OleDbDataReader.GetRowHandles()
at System.Data.OleDb.OleDbDataReader.ReadRowset()
at System.Data.OleDb.OleDbDataReader.Read()
at System.Data.OleDb.OleDbDataReader.HasRowsRead()
at System.Data.OleDb.OleDbDataReader.NextResult()
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, 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, Int32 startRecord, Int32 maxRecords, String srcTable)
at DreamweaverCtrls.DataSet.DoInit()<hr>System.Exception: The DefaultView was requested but no tables yet exist.
at DreamweaverCtrls.DataSet.get_DefaultView()<hr>System.Data.OleDb.OleDbException: Unspecified error
at System.Data.OleDb.OleDbDataReader.ProcessResults(Int32 hr)
at System.Data.OleDb.OleDbDataReader.GetRowHandles()
at System.Data.OleDb.OleDbDataReader.ReadRowset()
at System.Data.OleDb.OleDbDataReader.Read()
at System.Data.OleDb.OleDbDataReader.HasRowsRead()
at System.Data.OleDb.OleDbDataReader.NextResult()
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, 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, Int32 startRecord, Int32 maxRecords, String srcTable)
at DreamweaverCtrls.DataSet.DoInit()<hr>System.Exception: The DefaultView was requested but no tables yet exist.
at DreamweaverCtrls.DataSet.get_DefaultView()<hr>
 
I cannot tell you exactly what is wrong with your code,
but if you are working with SQL Server 2000, you are best
served by using the SQL Classes rather than the OleDb
classes. Those classes are designed to work with SQL
Server and will perform better.
-----Original Message-----
I have a asp.net (framework 1.1) site interfacing
Click to expand...
against SQL 2000. It runs like a charm 99% of the time
but once in a while I get the following "unspecified
error". Sometimes it would resolve by itself (asp.net
recycled?); it also can be solved by restarting IIS.
Any ideas what cause(s) this to happen?

System.Data.OleDb.OleDbException: Unspecified error
at System.Data.OleDb.OleDbDataReader.ProcessResults (Int32 hr)
at System.Data.OleDb.OleDbDataReader.GetRowHandles()
at System.Data.OleDb.OleDbDataReader.ReadRowset()
at System.Data.OleDb.OleDbDataReader.Read()
at System.Data.OleDb.OleDbDataReader.HasRowsRead()
at System.Data.OleDb.OleDbDataReader.NextResult()
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal
Click to expand...
(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteReader (CommandBehavior behavior)
at
Click to expand...
System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.Exec
uteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillFromCommand
Click to expand...
(Object data, Int32 startRecord, Int32 maxRecords, String
srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet
Click to expand...
dataSet, Int32 startRecord, Int32 maxRecords, String
srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet
Click to expand...
dataSet, Int32 startRecord, Int32 maxRecords, String
srcTable)
at DreamweaverCtrls.DataSet.DoInit()
Click to expand...
at System.Data.OleDb.OleDbDataReader.ProcessResults (Int32 hr)
at System.Data.OleDb.OleDbDataReader.GetRowHandles()
at System.Data.OleDb.OleDbDataReader.ReadRowset()
at System.Data.OleDb.OleDbDataReader.Read()
at System.Data.OleDb.OleDbDataReader.HasRowsRead()
at System.Data.OleDb.OleDbDataReader.NextResult()
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal
Click to expand...
(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteReader (CommandBehavior behavior)
at
Click to expand...
System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.Exec
uteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillFromCommand
Click to expand...
(Object data, Int32 startRecord, Int32 maxRecords, String
srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet
Click to expand...
dataSet, Int32 startRecord, Int32 maxRecords, String
srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet
Click to expand...
dataSet, Int32 startRecord, Int32 maxRecords, String
srcTable)
at DreamweaverCtrls.DataSet.DoInit()
Click to expand...
at DreamweaverCtrls.DataSet.get_DefaultView()
Click to expand...
at System.Data.OleDb.OleDbDataReader.ProcessResults (Int32 hr)
at System.Data.OleDb.OleDbDataReader.GetRowHandles()
at System.Data.OleDb.OleDbDataReader.ReadRowset()
at System.Data.OleDb.OleDbDataReader.Read()
at System.Data.OleDb.OleDbDataReader.HasRowsRead()
at System.Data.OleDb.OleDbDataReader.NextResult()
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal
Click to expand...
(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteReader (CommandBehavior behavior)
at
Click to expand...
System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.Exec
uteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillFromCommand
Click to expand...
(Object data, Int32 startRecord, Int32 maxRecords, String
srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet
Click to expand...
dataSet, Int32 startRecord, Int32 maxRecords, String
srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet
Click to expand...
dataSet, Int32 startRecord, Int32 maxRecords, String
srcTable)
 
Back
Top