OK, follow up to my previous post ... I ran a test procedure that stripped
it down to just a bare select query ... and it ran, so it's not a "driver
problem" per se.
There must be an error in my code ... if anybody has any tips to pass along
... here's my code:
<cfset request.start_date="1/1/80">
<cfset request.end_date=dateformat(now(), "m/d/yy")>
<cfstoredproc procedure="testProcedure"
datasource="#request.dsn#"
returncode="no">
<cfprocparam type="InOut"
cfsqltype="CF_SQL_DATE"
dbvarname="start_date"
variable="start_date"
value="#request.start_date#"
null="No">
<cfprocparam type="InOut"
cfsqltype="CF_SQL_DATE"
dbvarname="end_date"
variable="end_date"
value="#request.end_date#"
null="No">
<cfprocresult name="ArchiveDates"
resultset="1">
</cfstoredproc>
> -----Original Message-----
> From: Owens, Howard [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, January 13, 2003 5:19 PM
> To: CF-Talk
> Subject: StoreProc Driver question
>
> I'm trying to use CFSTOREDPROC for the first time, and I'm getting this
> error:
>
> [Microsoft][ODBC SQL Server Driver]Optional feature not implemented
>
> I'm running SQL Server 2000 Developers Edition on a Win2K machine ...
>
> Can't I use storedprocs with the developer edition? Am I missing some
> driver I should install? What the hell is going on!!!
>
> H.
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
