Hfm cannot create new connection because in manual or distributed transaction mode

 · Answers. 1) Check the datasouce, ensure you are using SQL Server Native Client provider. 2) Check the source database, if you have enabled snapshot isolation on the DataSource – if yes; make sure to turn MARS on (Multiple Active Result Sets). Edit the datasource, set the property MARS Connection to be true. Cannot create new connection because in manual or distributed transaction mode Suggested Work Around: Set "poFetchDetailsOnDemand" (for the Provider) to False. This is a known issue when it is set to True.3/5.  · OLE DB provider "SQLNCLI" for linked server "S1" returned message "Cannot create new connection because in manual or distributed transaction mode.". Msg , Level 16, State 2, Procedure.

The problem occurred because the transaction manager ignored the second connection that used the same resource manager. This was solved with a code fix. CR When allocating a new connection, the connector container used the descriptor MBean to obtain configuration information. OLE DB provider "SQLNCLI" for linked server "S1" returned message "Cannot create new connection because in manual or distributed transaction mode.". Msg , Level 16, State 2, Procedure. So this is for anyone like me that is browsing the. Cannot create new connection because in manual or distributed transaction mode. Applies to: Microsoft SQL Server, MailMarshal SMTP / OLE DB provider "SQLNCLI" for linked server "S1" returned message "Cannot create new connection because in manual or distributed transaction mode.".

Getting error "Cannot create new connection because in manual or distributed transaction mode" while executing query with linked server. Cannot create new connection because in manual or distributed transaction mode. When executing this classic ASP code. Cannot create new connection because in manual or distributed transaction mode. Suggested Work Around: Set "poFetchDetailsOnDemand" (for the Provider) to False.