scstoredproc problem

[Guest_imported]

i am getting this error:
ODBC Error Code = S1C00 (Driver not capable)

[Microsoft][ODBC SQL Server Driver]Optional feature not implemented

The error occurred while processing an element with a general identifier of (CFSTOREDPROC), occupying document position (161:10) to (161:81) in the template file D:\STORAGE\CUSTOMER FILES\INTRANET\COMMON\INCLUDES\INCLUDE_REPORT_CUSTOMER_NEW.CFM.

when running this stored proc:
<cfstoredproc procedure=&quot;spGetHourDetails&quot; datasource=&quot;#appDataSource#&quot;>
<cfprocparam type=&quot;In&quot; cfsqltype=&quot;CF_SQL_INTEGER&quot; dbvarname=&quot;@intprojectID&quot; value=&quot;#get_Projects.projectid#&quot;>
<cfprocparam type=&quot;in&quot; cfsqltype=&quot;CF_SQL_DATE&quot; dbvarname=&quot;@dteToDate&quot; value=&quot;#toDate#&quot;>
<cfprocparam type=&quot;in&quot; cfsqltype=&quot;CF_SQL_DATE&quot; dbvarname=&quot;@dteFromDate&quot; value=&quot;#fromDate#&quot;>
<cfprocresult name=&quot;sum_hours&quot;>
</cfstoredproc>

which, in the procedure, has this code.
CREATE PROCEDURE spGetHourDetails
as declare
@intProjectID int,
@dteFromDate datetime,
@dteToDate datetime
select hours.* , workcode.*
from hours, workcode
where hours.Projectid = @intProjectID
and hours.workcode = workcode.id
and hours.workdate >= @dteFromDate
and hours.workdate <= @dteToDate
order by workcode.code


any ideas?

 

[iza]

download a new driver ?