I am running an ASP page that opens an ADO connection to an MS SQL database. It starts up a transaction and then executes a series of statements (no SELECTs, only DELETEs and INSERTs). It seems that whenever one of the DELETE statements executed has a trigger associated with it, I get the following error:

Microsoft OLE DB Provider for SQL Server error '80004005'

Cannot create new connection because in manual or distributed transaction mode.
This error seems to normally occur when you have some pending action that isnt complete when you try to execute a command within a transaction. Supposedly this shouldn't happen if you set the DBPROP_MULTIPLECONNECTIONS property to false, but even when I set the property on the ADO Connection, (using: myConn.Properties("Multiple Connections") = False) I still get the error. I'm tearing my hair out over this one.
If I execute the same set of SQL statements in Query Analyzer as part of a transaction they execute without errors.