I discussed the insert trigger bug in an earlier thread and worked with Stephen Dupre at Macromedia to troubleshoot and confirm the bug. One of the bug fixes introduced in the 3.5 drivers was with insert triggers in SQL Server 2000. Unfortunately, the fix was just a swap from one bug to another. In SQL Server 2000, if I have an insert trigger that is supposed to return a result set, no result set is returned with the 3.5 drivers. With the 3.4 drivers, the result was that ColdFusion consumed 100% of the CPU time until it was restarted. This bug does not exist in the 3.3 drivers or earlier. Stephen Dupre said that the Microsoft JDBC drivers are based on older DataDirect drivers.
The bug is listed as a know issue on the DataDirect 3.5 download page. <http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=42dcb10a> -Mike Chabot On 11/7/05, Ken Wilson <[EMAIL PROTECTED]> wrote: > Can you elaborate on the nature of this insert trigger bug or perhaps > provide a pointer to descriptive info on it? > > Thanks, > > Ken > > > > On 11/7/05, Mike Chabot <[EMAIL PROTECTED]> wrote: > > > > Pete, > > I use the SQL Server JDBC drivers to get around a bug with insert > > triggers that is in the DataDirect 3.4 and 3.5 drivers. Otherwise, I > > was told that the DataDirect drivers are better. > > > > You can find setup instructions for the SQL Server drivers here: > > <http://www.bpurcell.org/blog/index.cfm?mode=entry&entry=981> > > > > The jTDS drivers are another option. > > <http://jtds.sourceforge.net> > > > > Enjoy, > > Mike Chabot > > > > On 11/5/05, Pete Ruckelshaus <[EMAIL PROTECTED]> wrote: > > > Is anyone using the Microsoft JDBC drivers for SQL Server with CFMX7? > > > If so, are there any advantages in using the MS JDBC drivers over the > > > ones that ship with MX? > > > > > > Followup question, when setting up an "other" type of DSN in CF > > > Administrator, what do you use for the "JDBC URL" setting? I'll > > > assume that the username and password are for the SQL Server account > > > that is being used... > > > > > > Thanks > > > > > > Pete ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:223450 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
