Unspecified error | FrameWork 1.1 | ASP.net | SQL 2000

[GotdotNet]

I get this error once in a while and I normally could fix it by restarting IIS. However, I would like to find out what causes this. Can anyone help?

-----------------------------error screen-----------------------------------

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 >

----------------------- web.config -----------------------------------------------------
<configuration> <appSettings><a dd key="CONNECTION _HANDLER_app_Co nn" value="default_ oledb.htm" /><add key="CONNECTION _STRING_app_Con n" value="Provider =SQLOLEDB.1;Pas sword=password; User ID=username;Ini tial Catalog=dbname; Data Source=123.123. 123.123" /><add key="CONNECTION _DATABASETYPE_a pp_Conn" value="OleDb" /><add key="CONNECTION _SCHEMA_app_Con n" value="" /><add key="CONNECTION _CATALOG_app_Co nn" value="" /></appSettings></configuration>

[Richard K Bethell]

"GotdotNet" <nv****@yahoo.c om> wrote in message
news:79******** *************** ***********@mic rosoft.com...

I get this error once in a while and I normally could fix it by restarting IIS. However, I would like to find out what causes this. Can anyone help?

For whatever reason, you appear to be working with a DataView for a table
that is not being brought into existence in your code. Two bits of advice
for getting a more meaningful error message:

a) Use the native System.Data.Sql Client provider, instead of OleDb, i.e.
instead of the OleDbDataAdapte r, use the SqlDataAdapter, etc.
b) Put the SQL execution inside a try/catch block, throw your own exception,
and then publish the info from the InnerException. Like this:

try
{
cmd.ExecuteNonQ uery();
}
catch (SqlException E)
{
System.Text.Str ingBuilder MyErr = new System.Text.Str ingBuilder();
MyErr.Append("A Data exception occured\r\n");
MyErr.Append("S ource: " + E.Source);
MyErr.Append("\ r\nMessage:" + E.Message);
if (E.InnerExcepti on != null)
{
MyErr.Append("\ r\nInner: " + E.InnerExceptio n.Message);
}
throw new SystemException (MyErr.ToString ());
}

[GotDotNet]

Rich - Thanks for your advice!

Here's the issue, where should I place the try/catch block in this page?

----------------------------------- sample.aspx -------------------------------------------------

<%@ Page Language="VB" ContentType="te xt/html" debug="false"%> <%@ Register TagPrefix="MM" Namespace="Drea mweaverCtrls" Assembly="Dream weaverCtrls,ver sion=1.0.0.0,pu blicKeyToken=83 6f606ede05d46a, culture=neutral " %><MM:DataSet
runat="Server"
id="GETStuff"
IsStoredProcedu re="true"
CreateDataSet=" true"
ConnectionStrin g='<%# System.Configur ation.Configura tionSettings.Ap pSettings("CONN ECTION_STRING_a pp_Conn") %>'
DatabaseType='< %# System.Configur ation.Configura tionSettings.Ap pSettings("CONN ECTION_DATABASE TYPE_app_Conn") %>'
CommandText="db o._RunSProc"
Debug="true"

<Parameters><P arameter Name="@id" Value='<%# IIf((Request.Qu eryString("id") <> Nothing), Request.QuerySt ring("id"), "") %>' Type="Integer" Direction="Inpu t" /><Parameter Name="@string" Value='<%# "Take this" %>' Type="VarChar" Direction="Inpu t" /></Parameters></MM:DataSet><MM: PageBind runat="server" PostBackBind="t rue" /><html><head><t itle>Test</title><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"></head><body><%

server.Execute( GETStuff.FieldV alue("NavTopHTM L", Container))
%><ASP:Repeate r runat="server" DataSource='<%# GETStuff.Defaul tView %>'><ItemTempla te><a href="goto.aspx ?id=<%# GETStuff.FieldV alue("id", Container) %>"><%# GETStuff.FieldV alue("Item", Container) %></a><Br></ItemTemplate></ASP:Repeater></body></html>

[GotDotNet]

Maybe I should format this for easier viewing:

<%@ Page Language="VB" ContentType="te xt/html" debug="false"%> <%@ Register TagPrefix="MM" Namespace="Drea mweaverCtrls" assembly="Dream weaverCtrls,ver sion=1.0.0.0,pu blicKeyToken=83 6f606ede05d46a, culture=neutral " %><MM:DataSet
runat="Server"
id="GETStuff"
IsStoredProcedu re="true"
CreateDataSet=" true"
ConnectionStrin g='<%# System.Configur ation.Configura tionSettings.Ap pSettings("CONN ECTION_STRING_a pp_Conn") %>'
DatabaseType='< %# System.Configur ation.Configura tionSettings.Ap pSettings("CONN ECTION_DATABASE TYPE_app_Conn")
%>'
CommandText="db o._RunSProc"
Debug="true"><P arameters><Para meter Name="@id" Value='<%# IIf((Request.Qu eryString("id") <> Nothing), Request.QuerySt ring("id"), "") %>' Type="Integer" Direction="Inpu t" /><Parameter Name="@string" Value='<%# "Take this" %>' Type="VarChar" Direction="Inpu t" /></Parameters></MM:DataSet><MM: PageBind runat="server" PostBackBind="t rue" /><html><head><t itle>Test</title><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"></head><body><% server.Execute( GETStuff.FieldV alue("NavTopHTM L", Container)) %><ASP:Repeate r runat="server" DataSource='<%# GETStuff.Defaul tView %>'><ItemTempla te><a href="goto.aspx ?id=<%# GETStuff.FieldV alue("id", Container) %>"><%# GETStuff.FieldV alue("Item", Container) %></a><Br></ItemTemplate></ASP:Repeater></body></html>