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. ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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
