> The DataDirect 3.4 drivers for SQL Server 2000 are causing CFMX 6.1 > to > hang when certain insert triggers are executed. I reverted to the 3.3 > drivers, but those have other problems with them. I just installed > the > Microsoft JDBC sp3 driver in hopes that it is better, and I am > wondering if anybody has any experience using this alternate driver? > I > have only done minimal testing with the new driver, but it seems to > work. > > SQL Server 2000 Driver for JDBC Service Pack 3 > <http://www.microsoft.com/downloads/details. aspx?f> amilyid=07287b11-0502-461a-b138-2aa54bfdc03a&displaylang=en#affinity> > > Thank you, > Mike Chabot
This was fixed in 3.4 build 57 (only build 50 is on the /support/coldfusion site). It's also fixed in 3.5. We're starting the beta today for 3.5 drivers so you might be a good candidate. Send me an email. Here is the DataDirect defect. DEF0001750 When using the executeUpdate() method to execute an INSERT statement on a table with an INSERT trigger, the update count from the trigger was returned instead of the count from the actual INSERT statement. Stephen Dupre Macromedia QA [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:219119 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
