System.Data.OleDb.OleDbException: Unspecified error

[T8]

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(I nt32 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.ExecuteReaderIntern al(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteReader(Comma ndBehavior behavior)
at System.Data.OleDb.OleDbCommand.System.Data.IDbComm and.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillFromCommand(O bject 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.O leDb.OleDbException: Unspecified error
at System.Data.OleDb.OleDbDataReader.ProcessResults(I nt32 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.ExecuteReaderIntern al(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteReader(Comma ndBehavior behavior)
at System.Data.OleDb.OleDbCommand.System.Data.IDbComm and.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillFromCommand(O bject 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.Except ion: The DefaultView was requested but no tables yet exist.
at DreamweaverCtrls.DataSet.get_DefaultView()<hr>Syst em.Data.OleDb.OleDbException: Unspecified error
at System.Data.OleDb.OleDbDataReader.ProcessResults(I nt32 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.ExecuteReaderIntern al(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteReader(Comma ndBehavior behavior)
at System.Data.OleDb.OleDbCommand.System.Data.IDbComm and.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillFromCommand(O bject 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.Except ion: The DefaultView was requested but no tables yet exist.
at DreamweaverCtrls.DataSet.get_DefaultView()<hr>

[Keith]

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 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.ExecuteReaderIntern al (CommandBehavior behavior, String method)at System.Data.OleDb.OleDbCommand.ExecuteReader (CommandBehavior behavior)at System.Data.OleDb.OleDbCommand.System.Data.IDbComm and.Exec
uteReader(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 errorat 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.ExecuteReaderIntern al (CommandBehavior behavior, String method)at System.Data.OleDb.OleDbCommand.ExecuteReader (CommandBehavior behavior)at System.Data.OleDb.OleDbCommand.System.Data.IDbComm and.Exec
uteReader(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 errorat 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.ExecuteReaderIntern al (CommandBehavior behavior, String method)at System.Data.OleDb.OleDbCommand.ExecuteReader (CommandBehavior behavior)at System.Data.OleDb.OleDbCommand.System.Data.IDbComm and.Exec
uteReader(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>
.