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.
|
|
|
|