For some reason my simple address db will work fine and then 1 or 2 entries later, I recieve a "DB overflow Error" listed below.

Does anyone know what I am doing wrong?

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

Overflow
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: Overflow

Source Error:


Line 90: dbCommand.Parameters.Add(cmtsParam);
Line 91:
Line 92: dbCommand.ExecuteNonQuery();
Line 93:
Line 94: dbConnection.Close();


Source File: C:\ASP.NET\data\CommandExecuteII.aspx Line: 92

Stack Trace:


[OleDbException (0x80040e57): Overflow]
   System.Data.OleDb.OleDbCommand.ExecuteCommandTextE rrorHandling(Int32 hr) +41
   System.Data.OleDb.OleDbCommand.ExecuteCommandTextF orSingleResult(tagDBPARAMS dbParams, Object& executeResult) +122
   System.Data.OleDb.OleDbCommand.ExecuteCommandText( Object& executeResult) +92
   System.Data.OleDb.OleDbCommand.ExecuteCommand(Comm andBehavior behavior, Object& executeResult) +65
   System.Data.OleDb.OleDbCommand.ExecuteReaderIntern al(CommandBehavior behavior, String method) +112
   System.Data.OleDb.OleDbCommand.ExecuteNonQuery() +66
   ASP.CommandExecuteII_aspx.btnRun_Click(Object sender, EventArgs e) in C:\ASP.NET\data\CommandExecuteII.aspx:92
   System.Web.UI.WebControls.Button.OnClick(EventArgs e) +83
   System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.RaisePostBackEvent(String eventArgument) +57
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler sourceControl, String eventArgument) +18
   System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData) +33
   System.Web.UI.Page.ProcessRequestMain() +1277

try to execute the query separately

Ahmed Ali
Software Developer

I have had some similar problems. It might be something to do with type conversion problems. Try it in debug mode and see whether you are passing the correct data types to query.