General information
Category:
Database DAO/RDO/ODBC/ADO
>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?
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only