System.Data.OleDb.OleDbException: Unspecified error

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>
 
K

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
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unspecified error | FrameWork 1.1 | ASP.net | SQL 2000 3
Issue with importing CSV file using JET. Error Message: 'Cannot update. Database or object is read- 1
SQL Timeout 1
Simple SQL question. Can you check what am i doing wrong? Thank You. 1
Timeout on populating a datagrid 4
wtf 3
[OleDbException (0x80004005): Unspecified error] 7
ASP.net and Oracle error System.Data.OleDb.OleDbException 5

Members online

Total: 34 (members: 1, guests: 33)
Robots: 305

Forum statistics

Threads
473,755
Messages
2,569,536
Members
45,008
Latest member
HaroldDark

Latest Threads

Top