Perhaps it's the driver, not the DB. Can you try a native driver rather than an ODBC one?
On 12/18/05, Mike Kear <[EMAIL PROTECTED]> wrote: > Not sure if this is best directed at the CF=Talk list or teh SQLServer > list, but anyway ..... > > Whenever I use cfqueryparam with cfsqltype="cf_sql_timestamp", I get the > following error: > > [quote] > Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server > Driver]Optional feature not implemented > [/quote] > > My SQLServer is a default installation I thought - well at least in respect > to data types anyway. Does anyone know what feature is missing from my > SQLServer? And do i just have to get the SQLServer CD and install whatever > it is? > > The only workaround I've found so far is to just remove the cfqueryparam > and use #createodbcdatetime(now())# instead which gets me by but isnt very > satisfactory. -- CFAJAX docs and other useful articles: http://jr-holmes.coldfusionjournal.com/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:227235 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