By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,952 Members | 1,722 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,952 IT Pros & Developers. It's quick & easy.

System.Data.OleDb.OleDbException: Unspecified error

P: n/a
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>
Nov 17 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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>
.

Nov 17 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.