System.Data.OleDb.OleDbException: Parameter ?_1 has no default value

Discussion in 'Microsoft C# .NET' started by silesius, Nov 16, 2004.

  1. silesius

    silesius Guest

    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 information. Customer logs in, I
    store the username they log in with in the session state and on the
    following page use it in my parameterized query to retrieve customers info.
    I'm using a data adapter with a dataset. Anyway, since I moved the
    application to the remote server I started getting the following error after
    logging in, but not all the time, sometimes it works fine. I'm relatively
    new to ASP.NET and would appreciate it if someone could point me in the
    right direction. TIA

    Parameter ?_1 has no default value.
    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: Parameter ?_1 has no
    default value.

    Source Error:

    An unhandled exception was generated during the execution of the current web
    request. Information regarding the origin and location of the exception can
    be identified using the exception stack trace below.

    Stack Trace:

    [OleDbException (0x80040e10): Parameter ?_1 has no default value.]
    System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr)
    +41
    System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS
    dbParams, Object& executeResult) +174
    System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
    +92
    System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior,
    Object& executeResult) +65
    System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior
    behavior, String method) +112
    System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)
    +69
    System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior
    behavior) +5
    System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32
    startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
    CommandBehavior behavior) +304
    System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord,
    Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior
    behavior) +77
    System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +38
    MaxCustInfo.WebForm1.Page_Load(Object sender, EventArgs e) in
    c:\documents and
    settings\richard\vswebcache\www.bielmax.com\maccustinfo\customerform.aspx.cs:74
    System.Web.UI.Control.OnLoad(EventArgs e) +67
    System.Web.UI.Control.LoadRecursive() +35
    System.Web.UI.Page.ProcessRequestMain() +750
     
    silesius, Nov 16, 2004
    #1
    1. Advertisements

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. G.Esmeijer

    Help: System.Data.OleDb.OleDbException Error

    G.Esmeijer, May 22, 2004, in forum: Microsoft C# .NET
    Replies:
    3
    Views:
    365
    Frans Bouma [C# MVP]
    May 23, 2004
  2. Brian
    Replies:
    1
    Views:
    258
    Dmitriy Lapshin [C# / .NET MVP]
    Dec 21, 2004
  3. Brian
    Replies:
    1
    Views:
    123
    Guest
    Dec 21, 2004
  4. Brian
    Replies:
    1
    Views:
    139
    Guest
    Dec 21, 2004
  5. sirinath
    Replies:
    1
    Views:
    1,299
    sirinath
    Oct 8, 2007
Loading...

Share This Page