using
[code language=’vb’]
cmd.Parameters.Append cmd.CreateParameter("@dtDate", adDate, adParamInput, 0, "11/13/2008")
[/code]
it would return this error:
"Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done."
Fix by using adDBTimeStamp