We have installed the Merant ODBC in order to access a Progress 91d database using a datalink in SQL Server. Our application uses Microsoft Transaction Server and when trying to access the data linked , SQL Server refuses this as the MERANT driver does not support distributed transactions (??) Error: "Distributed Transaction Completed. either enlist this session in a new transaction ot the NULL Transaction"


We manage to access data from Query Analyzer (without MTS and hence no distributed transaction), but when trying to access the Progress from our application we get the error above. We have tried to set the flag "OLE DB Services=-3" to disable transactions to the Progress database, but still, we get the error message above.

Anybody got an idea what to do in order to get access to the Progress database using Microsoft Transaction Server accessing a database link in SQL Server?