>I am trying to change the ADO Provider from MSDASQL to SQLOLEDB. When I try to run the application, I get the message.
>" Cannot create a new connection while in manual transaction mode".
>Debug leads to a line "db.execute SQL". This statement is between BeginTrans and Committrans.
I believe you can't change providers on an open connection object. Or, it does not make a lot of sense to be specifying connection parameters within a transaction. Maybe if you expand a little?