Hi,
I can not insert the value to exsting item in table. The database based on microsoft acess. My code as follow:

Dim DbPath As String = Server.MapPath("database.mdb")
        Dim ConnStr As String
        ConnStr = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & DbPath & ";"
        Dim MyOleDbConn As New OleDbConnection(ConnStr)
        MyOleDbConn.Open()
dim sql_npvtpc as string
        sql_npvtpc = "SELECT output.Project_ID, output.TPCNPV FROM [output]"
        Dim MyOleDbCommand_npvtpc As New OleDbCommand(sql_npvtpc, MyOleDbConn)
        Dim da_npvtpc As New OleDbDataAdapter(MyOleDbCommand_npvtpc)
        Dim scb As New OleDbCommandBuilder(da_npvtpc)

        Dim tb_npvtpc As DataTable
        ds_npvtpc = New DataSet
        da_npvtpc.Fill(ds_npvtpc, "output")
        tb_npvtpc = ds_npvtpc.Tables("output")
        Dim dr_npvtpc As DataRow
        dr_npvtpc = ds_npvtpc.Tables(0).NewRow()

        ' input data to new row
        Dim npvtpc As Integer = 5
        dr_npvtpc.Item(0) = a 'session("project1")
        dr_npvtpc.Item("tpcnpv") = npvtpc
        ds_npvtpc.Tables(0).Rows.Add(dr_npvtpc)
        da_npvtpc.Update(ds_npvtpc, "output")

        MyOleDbConn.Close() 'Close connection



And the error message is as follows:

Server Error in '/DSS' Application.
--------------------------------------------------------------------------------

IErrorInfo.GetDescription failed with E_FAIL(0x80004005).
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: IErrorInfo.GetDescription failed with E_FAIL(0x80004005).

Source Error:


Line 254: Dim tb_npvtpc As DataTable
Line 255: ds_npvtpc = New DataSet
Line 256: da_npvtpc.Fill(ds_npvtpc, "output")
Line 257: tb_npvtpc = ds_npvtpc.Tables("output")
Line 258: Dim dr_npvtpc As DataRow


Source File: C:\Inetpub\wwwroot\DSS\output.aspx.vb Line: 256

Stack Trace:


[OleDbException (0x80004005): IErrorInfo.GetDescription failed with E_FAIL(0x80004005).]
   System.Data.OleDb.OleDbCommand.ExecuteCommandTextE rrorHandling(Int32 hr)
   System.Data.OleDb.OleDbCommand.ExecuteCommandTextF orSingleResult(tagDBPARAMS dbParams, Object& executeResult)
   System.Data.OleDb.OleDbCommand.ExecuteCommandText( Object& executeResult)
   System.Data.OleDb.OleDbCommand.ExecuteCommand(Comm andBehavior behavior, Object& executeResult)
   System.Data.OleDb.OleDbCommand.ExecuteReaderIntern al(CommandBehavior behavior, String method)
   System.Data.OleDb.OleDbCommand.ExecuteReader(Comma ndBehavior behavior)
   System.Data.OleDb.OleDbCommand.System.Data.IDbComm and.ExecuteReader(CommandBehavior behavior)
   System.Data.Common.DbDataAdapter.FillFromCommand(O bject data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
   DSS.output.test() in C:\Inetpub\wwwroot\DSS\output.aspx.vb:256
   DSS.output.output_back_ServerClick(Object sender, EventArgs e) in C:\Inetpub\wwwroot\DSS\output.aspx.vb:291
   System.Web.UI.HtmlControls.HtmlInputButton.OnServe rClick(EventArgs e)
   System.Web.UI.HtmlControls.HtmlInputButton.System. Web.UI.IPostBackEventHandler.RaisePostBackEvent(St ring eventArgument)
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler sourceControl, String eventArgument)
   System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData)
   System.Web.UI.Page.ProcessRequestMain()




--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573


Please, please help me to cover this problem. Thank a ton

I had a similar encounter; I found those messages were being generated because of reserved field names being used (in my instance, one of my tables had a field called 'Status' which caused it return similar errors to yours.)

Try searching for perceived reserved field names, change them and try again.

There are 10 types of people in this world; those who understand binary, and those who don't

Hi, guys:

I'm new in your forum. I have a problem very similar to the one posted by vandat but in my case I'm running an application in a Sybase DB. I have the following code:

using System;
using System.Configuration;
using System.Data;
using System.Data.OleDb;
using System.Reflection;
using System.EnterpriseServices;
using System.Runtime.InteropServices;
using System.Runtime.Serialization;

[assembly: ApplicationName ( "DistributedTransaction" ) ]
[assembly: ApplicationActivation ( ActivationOption.Library ) ]

namespace TestEnterpriseServices
{
    [ Transaction ( TransactionOption.Required ) ]
    public class DistributedTransactionSybase : ServicedComponent
    {
        public DistributedTransactionSybase ()
        {
        }

        [ System.EnterpriseServices.AutoComplete() ]
        public void NewItem ()
        {
            OleDbConnection con = null;

            try
            {
                con = new OleDbConnection ( ConfigurationSettings.AppSettings["CnnSybase"] );
                con.Open ();
            }

            catch ( Exception e )
            {
                throw ( e );
            }
        }
    }
}

As you can see I don't have any queries, or operations that modify data. Nothing but a simple open method. When the application executes the open method I get the following error:

No error information available: E_FAIL(0x80004005).

I really don't understand what is causing this error. I've been searching the web for a while without any look! I really would appreciate any ideas to work around this problem.

Thank you.

The folks over on the MS forums might be able to help you better with this (I saw your post there as well) since this is extremely cryptic and I have no experience with Sysbase but one thing I would suggest is that you do something with your execption besides doing this:

throw(e);

This is 1) A bad way to control program flow and 2) One of the most resource intensive things you can do inside an application.

Hope you get your problem solved.

-------------------------
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

^^Thats my signature

Hi, again:

Thank you four your advice regarding to the exception management. I handle this in that way because it is an application build in tiers. The code shown before corresponds to a dll on the business tier runing on the application server and I throw it to the presentation layer to display the message there. I don't know what else can I do in a dll runing on a server.

I don't expect that you or anyone else do my job, but it would be helpful if you give some advice (as the one you give with the exception). Thank you again.

Ugg. My last post was somewhat vauge and you will have to forgive, it was late and I had been up way to long so my post came out a bit unclear and I just skimmed your code briefly.

Exception handling is expesnive no matter how you handle the exception and in this case you are doing everything effeciently as possible (also given your infastructure that is the best way).

Sorry for the confusion.

-------------------------
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

^^Thats my signature