MS SQL Server tends to return the "optional feature not implemented" error any time the cf_sql_date option is used with <cfqueryparam> or <cfprocparam> ... SQL Server only understands cf_sql_timestamp in my experience... However... I've also seen SQL Server report the same error in some cases when the order of the parameters in a cfstoredproc tag was incorrect and it attempts to put a date into a non-date parameter or vice versa. Granted, that doesn't seem to jive with it only happening on this one machine... though I suppose it's possible if there is conditional logic aroung the <cfprocparam> tags.
> Thanks...tried that (and they work - getting the error for > every stored > procedure...the application runs on other machines) and > hard to debug when > you get no data. I now down to the option of it being the > ODBC driver > itself, as it seems to stall on only this machine... > D > -----Original Message----- > From: Al Everett [mailto:[EMAIL PROTECTED] > Sent: Monday, February 07, 2005 8:47 AM > To: CF-Talk > Subject: Re: Stored procedure error > I've always found that error to be thrown by Oracle when > it can't tell > you what the error is. It is singularly unhelpful. > I would start with your proc. Run it outside of CF to see > if you get a > better error message. > On Sun, 6 Feb 2005 22:38:25 -0500, Doug Hyde > <[EMAIL PROTECTED]> wrote: >> Anybody ever encounter this error? >> >> [Microsoft][ODBC SQL Server Driver]Optional feature not >> implemented >> >> It seems to be related to a stored procedure call. See >> below. >> >> Doug >> >> ----------- >> >> Type Database >> Query Error [Microsoft][ODBC SQL Server >> Driver]Optional feature not >> implemented >> Native Error Code 0 >> SQL State S1C00 >> SQL { call spVisit(?,?,?,?) } >> Tag Context CFINCLUDE: Line=1; Column=1 >> | >> +-- CFIF: Line=15; Column=1 >> | >> +-- CFELSE: Line=26; Column=1 >> | >> +-- CFOUTPUT: Line=55; Column=1 >> | >> +-- CFIF: Line=90; Column=1 >> | >> +-- CFELSEIF: Line=113; Column=1 >> | >> +-- CFIF: Line=123; Column=1 >> | >> +-- CFELSEIF: Line=138; Column=1 >> | >> +-- CFINCLUDE: Line=142; >> Column=2 >> | >> +-- CFOUTPUT: Line=14; >> Column=1 >> | >> +-- CFINCLUDE: >> Line=30; Column=22 >> | >> +-- CFOUTPUT: >> Line=5; Column=1 >> | >> +-- >> CFSTOREDPROC: >> Line=79; >> Column=1 >> Source >> >> 76: </cfif> >> 77: </cfif> >> 78: >> 79: <cfstoredproc datasource="#dsn#" procedure="spVisit"> >> 80: <cfprocparam dbvarname="userID" >> cfsqltype="CF_SQL_INTEGER" >> value="#userID#" type="In"> >> >> ^ Snippet from underlying CFML source >> >> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193476 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
