CodeCharge Studio
search Register Login  

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> .NET

 Date error 22018

Print topic Send  topic

Author Message
LV
Posted: 12/01/2005, 8:10 PM

My Date field search doesn't work, if I left the Date blank and click on Search it works, but if I enter or select a date from the Calendar it gives me the error below anyone have any idea why?
I am using Access Database and all of my Dates are format as mm/dd/yyyy.

Thanks for any help.

======================

ERROR [22018] [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
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.Odbc.OdbcException: ERROR [22018] [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.

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:


[OdbcException: ERROR [22018] [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.]
TeamCalendar.Data_Entry.tblTeamCalendarDataProvider.GetResultSet(Int32& _PagesCount) +4456
TeamCalendar.Data_Entry.Data_EntryPage.tblTeamCalendarBind() +275
TeamCalendar.Data_Entry.Data_EntryPage.OnLoad(EventArgs e) +79
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +750




--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET Version:1.1.4322.2032
LV
Posted: 12/01/2005, 9:07 PM

Never mind, I found my problem.

My Server connection using the wrong Database provider change it to MSAccess took care of my problem.

:-)

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Web Database

Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by UltraApps.com  and YesSoftware, Inc.