Hi All, I'm wondering if anyone has any experience with the jTDS driver (http://jtds.sourceforge.net) and Coldfusion 8. I'm running this on Win2003 box (32 bit), Cf 8.0 and sql server 2005.
I've set up the driver, and can use it to successfully fetch queries with a substantial speed improvement, and even more so under load. Unfortunately it's not 100% compatible with the existing data direct driver. I'm unable to get a result for: select scope_identity() as id The ID column returns an empty string. However, if I switch back to the old data direct drivers the query returns an Id, as expected. Any insight would be greatly appreciated. -j ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304695 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4