rito1
asked on
Date Parameter - System.Data.OleDb.OleDbException: Data type mismatch in criteria expression.
Hi All,
I am working on an ASP.NET website which uses MS Access as a database.
I am trying to pass a date parameter into an Access query but get the following error when executing the OleDbCommand:
System.Data.OleDb.OleDbExc eption: Data type mismatch in criteria expression.
I have double checked that my parameter is formatted as a date using the DateTime data type within ASP.NET.
Is there something else I should know about MS Access date formats which could be causing this issue?
Thanks,
Rit
I am working on an ASP.NET website which uses MS Access as a database.
I am trying to pass a date parameter into an Access query but get the following error when executing the OleDbCommand:
System.Data.OleDb.OleDbExc
I have double checked that my parameter is formatted as a date using the DateTime data type within ASP.NET.
Is there something else I should know about MS Access date formats which could be causing this issue?
Thanks,
Rit
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks,
Rich