473,567 Members | 2,956 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

System.Data.Ole Db.OleDbExcepti on: 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 "unspecifie d 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.Ole Db.OleDbExcepti on: Unspecified error
at System.Data.Ole Db.OleDbDataRea der.ProcessResu lts(Int32 hr)
at System.Data.Ole Db.OleDbDataRea der.GetRowHandl es()
at System.Data.Ole Db.OleDbDataRea der.ReadRowset( )
at System.Data.Ole Db.OleDbDataRea der.Read()
at System.Data.Ole Db.OleDbDataRea der.HasRowsRead ()
at System.Data.Ole Db.OleDbDataRea der.NextResult( )
at System.Data.Ole Db.OleDbCommand .ExecuteReaderI nternal(Command Behavior behavior, String method)
at System.Data.Ole Db.OleDbCommand .ExecuteReader( CommandBehavior behavior)
at System.Data.Ole Db.OleDbCommand .System.Data.ID bCommand.Execut eReader(Command Behavior behavior)
at System.Data.Com mon.DbDataAdapt er.FillFromComm and(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable)
at DreamweaverCtrl s.DataSet.DoIni t()<hr>System.D ata.OleDb.OleDb Exception: Unspecified error
at System.Data.Ole Db.OleDbDataRea der.ProcessResu lts(Int32 hr)
at System.Data.Ole Db.OleDbDataRea der.GetRowHandl es()
at System.Data.Ole Db.OleDbDataRea der.ReadRowset( )
at System.Data.Ole Db.OleDbDataRea der.Read()
at System.Data.Ole Db.OleDbDataRea der.HasRowsRead ()
at System.Data.Ole Db.OleDbDataRea der.NextResult( )
at System.Data.Ole Db.OleDbCommand .ExecuteReaderI nternal(Command Behavior behavior, String method)
at System.Data.Ole Db.OleDbCommand .ExecuteReader( CommandBehavior behavior)
at System.Data.Ole Db.OleDbCommand .System.Data.ID bCommand.Execut eReader(Command Behavior behavior)
at System.Data.Com mon.DbDataAdapt er.FillFromComm and(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable)
at DreamweaverCtrl s.DataSet.DoIni t()<hr>System.E xception: The DefaultView was requested but no tables yet exist.
at DreamweaverCtrl s.DataSet.get_D efaultView()<hr >System.Data.Ol eDb.OleDbExcept ion: Unspecified error
at System.Data.Ole Db.OleDbDataRea der.ProcessResu lts(Int32 hr)
at System.Data.Ole Db.OleDbDataRea der.GetRowHandl es()
at System.Data.Ole Db.OleDbDataRea der.ReadRowset( )
at System.Data.Ole Db.OleDbDataRea der.Read()
at System.Data.Ole Db.OleDbDataRea der.HasRowsRead ()
at System.Data.Ole Db.OleDbDataRea der.NextResult( )
at System.Data.Ole Db.OleDbCommand .ExecuteReaderI nternal(Command Behavior behavior, String method)
at System.Data.Ole Db.OleDbCommand .ExecuteReader( CommandBehavior behavior)
at System.Data.Ole Db.OleDbCommand .System.Data.ID bCommand.Execut eReader(Command Behavior behavior)
at System.Data.Com mon.DbDataAdapt er.FillFromComm and(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable)
at DreamweaverCtrl s.DataSet.DoIni t()<hr>System.E xception: The DefaultView was requested but no tables yet exist.
at DreamweaverCtrl s.DataSet.get_D efaultView()<hr >
Nov 17 '05 #1
1 6835
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 "unspecifie d
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.Ol eDb.OleDbExcept ion: Unspecified error
at System.Data.Ole Db.OleDbDataRea der.ProcessResu lts (Int32 hr)at System.Data.Ole Db.OleDbDataRea der.GetRowHandl es()
at System.Data.Ole Db.OleDbDataRea der.ReadRowset( )
at System.Data.Ole Db.OleDbDataRea der.Read()
at System.Data.Ole Db.OleDbDataRea der.HasRowsRead ()
at System.Data.Ole Db.OleDbDataRea der.NextResult( )
at System.Data.Ole Db.OleDbCommand .ExecuteReaderI nternal (CommandBehavio r behavior, String method)at System.Data.Ole Db.OleDbCommand .ExecuteReader (CommandBehavio r behavior)at System.Data.Ole Db.OleDbCommand .System.Data.ID bCommand.Exec
uteReader(Comma ndBehavior behavior)at System.Data.Com mon.DbDataAdapt er.FillFromComm and (Object data, Int32 startRecord, Int32 maxRecords, String
srcTable, IDbCommand command, CommandBehavior behavior)at System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String
srcTable, IDbCommand command, CommandBehavior behavior)at System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String
srcTable)at DreamweaverCtrl s.DataSet.DoIni t() <hr>System.Data .OleDb.OleDbExc eption: Unspecified errorat System.Data.Ole Db.OleDbDataRea der.ProcessResu lts (Int32 hr)at System.Data.Ole Db.OleDbDataRea der.GetRowHandl es()
at System.Data.Ole Db.OleDbDataRea der.ReadRowset( )
at System.Data.Ole Db.OleDbDataRea der.Read()
at System.Data.Ole Db.OleDbDataRea der.HasRowsRead ()
at System.Data.Ole Db.OleDbDataRea der.NextResult( )
at System.Data.Ole Db.OleDbCommand .ExecuteReaderI nternal (CommandBehavio r behavior, String method)at System.Data.Ole Db.OleDbCommand .ExecuteReader (CommandBehavio r behavior)at System.Data.Ole Db.OleDbCommand .System.Data.ID bCommand.Exec
uteReader(Comma ndBehavior behavior)at System.Data.Com mon.DbDataAdapt er.FillFromComm and (Object data, Int32 startRecord, Int32 maxRecords, String
srcTable, IDbCommand command, CommandBehavior behavior)at System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String
srcTable, IDbCommand command, CommandBehavior behavior)at System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String
srcTable)at DreamweaverCtrl s.DataSet.DoIni t() <hr>System.Exce ption: The DefaultView was requested but
no tables yet exist.at DreamweaverCtrl s.DataSet.get_D efaultView() <hr>System.Data .OleDb.OleDbExc eption: Unspecified errorat System.Data.Ole Db.OleDbDataRea der.ProcessResu lts (Int32 hr)at System.Data.Ole Db.OleDbDataRea der.GetRowHandl es()
at System.Data.Ole Db.OleDbDataRea der.ReadRowset( )
at System.Data.Ole Db.OleDbDataRea der.Read()
at System.Data.Ole Db.OleDbDataRea der.HasRowsRead ()
at System.Data.Ole Db.OleDbDataRea der.NextResult( )
at System.Data.Ole Db.OleDbCommand .ExecuteReaderI nternal (CommandBehavio r behavior, String method)at System.Data.Ole Db.OleDbCommand .ExecuteReader (CommandBehavio r behavior)at System.Data.Ole Db.OleDbCommand .System.Data.ID bCommand.Exec
uteReader(Comma ndBehavior behavior)at System.Data.Com mon.DbDataAdapt er.FillFromComm and (Object data, Int32 startRecord, Int32 maxRecords, String
srcTable, IDbCommand command, CommandBehavior behavior)at System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String
srcTable, IDbCommand command, CommandBehavior behavior)at System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String
srcTable)at DreamweaverCtrl s.DataSet.DoIni t() <hr>System.Exce ption: The DefaultView was requested but
no tables yet exist.at DreamweaverCtrl s.DataSet.get_D efaultView()<hr >
.

Nov 17 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
5410
by: G.Esmeijer | last post by:
Friends, The following code works fin. BUT... after a >> couple times<< this code is used is a class it comes with an error saying unhandled System.Data.OleDb.OleDbException' occurred in system.data.dll Any suggestions what could be wrong.
0
5272
by: silesius | last post by:
I've been using VS 2003 to develop a webapplication using C#. Today I exported the application to a remote webserver I begun experiencing problems. It's a simple application that retrieves some information from an Access database. It worked fine when I ran on my computer. I use a parameterized query to retrieve some customer specific...
0
2748
by: silesius | last post by:
I've been using VS.NET 2003 to develop a webapplication using C#. Today I exported the application to another webserver I begun experiencing problems. It's a simple application that retrieves some information from an Access database. It worked fine when I ran on my home computer. I use a datagrid witha a dataset and a parameterized query...
3
8816
by: Brian Foree | last post by:
I am developing an ASP.NET application that uses Access 2000 as its backend, and have just started getting the following error on 2 ASP.NET pages that had been working until late last week (and I don't think I made any changes to either page other than changing the user control that creates the header). Server Error in '/myApp' Application....
0
5630
by: NicK chlam via DotNetMonster.com | last post by:
this is the error i get System.Data.OleDb.OleDbException: Syntax error in INSERT INTO statement. at System.Data.Common.DbDataAdapter.Update(DataRow dataRows, DataTableMapping tableMapping) at System.Data.Common.DbDataAdapter.Update(DataSet dataSet, String srcTable) at System.Data.Common.DbDataAdapter.Update(DataSet dataSet) at...
5
9635
by: petro | last post by:
Hello all, My asp.net web application works on my machine but I get the following error on our test web server, There is only one oracle home on the test server. Does anyone know how to resolve this error? Oracle error occurred, but error message could not be retrieved from Oracle. Description: An unhandled exception occurred during the...
3
3222
by: Sarah | last post by:
I have a function residing in a module that is doing some file copy and database query operations. This function is called from a regular form under a System.Windows.Forms.Timer control. The problem is that sometimes it gives an error - even when it is doing the same exact operations. It may fail on the 20th tick event or the 100th. The file...
0
1632
by: John G | last post by:
I have been using Oracle Helper to connect to my oracle 9i Db. When excute text it works fine, but when I try to execute a store procedure I get the following error message. I searched everyplace for a solution. System.Data.OleDb.OleDbException: ̸Ώ System.Data.OleDb.OleDbCommand.ExecuteCommandTextForMultpleResults(tagDBPARAMS...
2
8976
by: psychomad | last post by:
Please, can someone help me out to solve this error, i've been searching throughout my codes and yet i didnt succeed in finding the error!!!! The Error is: Server Error in '/' Application. -------------------------------------------------------------------------------- Data type mismatch in criteria expression.
0
7690
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, well explore What is ONU, What Is Router, ONU & Routers main...
0
7909
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
8115
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7654
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
7961
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6273
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development projectplanning, coding, testing, and deploymentwithout human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
0
3630
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2093
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1206
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.