469,910 Members | 1,509 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,910 developers. It's quick & easy.

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

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.ExecuteCommandTextE rrorHandling(Int32 hr)
+41
System.Data.OleDb.OleDbCommand.ExecuteCommandTextF orSingleResult(tagDBPARAMS
dbParams, Object& executeResult) +174
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.ExecuteReader(Comma ndBehavior behavior)
+69
System.Data.OleDb.OleDbCommand.System.Data.IDbComm and.ExecuteReader(CommandBehavior
behavior) +5
System.Data.Common.DbDataAdapter.FillFromCommand(O bject 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\http://www.bielmax.com\maccustinfo\c...orm.aspx.cs:74
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +750
Nov 16 '05 #1
0 5031

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by G.Esmeijer | last post: by
reply views Thread by NicK chlam via DotNetMonster.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.