I have a store procedure which has one of the input variable as date
type "datetime", then a command object with the appending parameters
for this datetime fields(date type addate) was used, and the
command.execute was run to insert the date type of variable to the
database.

When I run this through the SQLOLEDB connection, it works fine.
When I run this through the ODBC for SQL Server Driver, it failed with
the following error:

Error Code:-2147217887
Error.Description:
[Microsoft][ODBC SQL Server Driver]Optional feature not implemented

Anyone has any experience on e this? Any suggestions?

- Min