I found this on deja.com and thought it might help you... From: Jeff Kohn ([EMAIL PROTECTED]) Subject: Re: New transaction cannot enlist in the specified transaction coordinator. Newsgroups: microsoft.public.platformsdk.complus_mts View this article only Date: 2001-07-25 10:28:51 PST
I just ran into this problem in an all-MS environment (ie SQL Server not Orcacle), and in my case the cause was having a firehose recordset open. If you open a recordset using adOpenForwardOnly, adLockReadOnly (cursorless resultset), then no other component will be able to enlist in the transaction as long as that recordset is open. This seems like an incredibly ridiculous limitation, but in my case it was definitely the cause of the problem. Restructoring the code so that I could close the firehose recordset fixed the problem. Unfortunately, if that's not an option for you, the only other thing you can do is change the recordset to use some type of cursor (adOpenStatic, for instance), which may negatively affect performance. There can be other causes for the error message you're getting, so make sure you've checked the obvious stuff like making sure DTC is running, etc. But I had never seen this particular explanation for the error, so maybe it's worth checking in your case. Jeff -----Original Message----- From: Rick Walters [mailto:[EMAIL PROTECTED]] Sent: Monday, April 01, 2002 11:13 AM To: CF-Talk Subject: MSSQL 2K Transaction Error Hi, Anyone seen this error before? (I'm using SQL Server 2000) [[ ODBC Error Code = 01000 (General warning) [Microsoft][ODBC SQL Server Driver][SQL Server][OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ] SQL = "update secure.website.dbo.people set token = 'IUIHIOYNTKI', updated = getdate() where peopleid = 111" ]] I have just moved to a new database server and my existing code is bombing on the transaciton tags I have surrounding my update statements. When I remove the CFTRANSATION tags I don't get the errors and the update statement executes without errors. Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 DaVita Inc. ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
