ADO中执行存储过程如何传递datetime类型？

[s5689412]

bool db_set_inform_device(time_t CurrentTime)
{
COleDateTime currentTime(CurrentTime);
CADOParameter paramCurrentTime(CADORecordset::typeDate, sizeof(DATE));
paramCurrentTime.SetValue(currentTime);
......
}

在执行的时候老是报数据超出范围的错误0x80040e21，有没有谁遇到过类似问题？
我使用的是codeproject上封装的ado类。

[s5689412]

已经找到错误源头，因为SQL Server不支持adDate数据类型，所以要改用typeDBTimeStamp。

具体见KB：Q214459

When the sample code is run, it gives this error:
Run-time error '2147217887 (80040e21)':
[Microsoft][ODBC SQL Server Driver] Optional feature not Implemented.
This is because SQL Server does not support the adDBDate datatype. To correct this problem, change the datatype of the @theDate parameter to adDBTimeStamp.

In order to determine the number, names, types, and sizes of parameters needed in a stored procedure, use the Parameters.Refresh method of the command object. You can call this method during development of your application to determine the correct requirements for the stored procedure, then remove the expensive call to Parameters.Refresh after you have gathered the necessary data.

[Yang_]

一般来说，执行存储过程可以简单的传送sql语句
exec procname 参数
如
exec procname '2006-7-1'

[Yang_]

我的意思是，这样就不必使用CADOParameter，CADOCommand了

[黑子白子]

ado通用变量类型是_variant_t（也是COM通用类型），转换为_variant_t类型即可，具体看MSDN吧。