Kbase P37530: SQL Server error 7391 while attempting a distributed transaction.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/26/2006 |
|
Status: Unverified
SYMPTOM(s):
Running a stored procedure on MSSQL to insert/update rows wrapped in a transaction fail
SQL Server error 7391 while running an insert SQL on a linked table
Linked Server
Server: Msg 7391, Level 16, State 1, Proc MSSQLTrigger Line 4
The operation could not be performed because the OLE DB provider 'MSDASQL' was
unable to begin a distributed transaction.
[OLE/DB provider returned message: [DataDirect-Technologies][ODBC PROGRESS driver]Optional feature not implemented.]
CAUSE:
The SQL92 engine does not support distrubuted transactions. There are plans
for SQL92 to support distributed transactions in the J2EE envirorment using
the Java Transaction API's in V10.
FIX:
As such also the Datadirect Connect 3.50, 3.60, 4.10, 4.20, 5.1 drivers for ODBC do not supportDistributed transactions and will return: "Optional feature not implemented"when the ODBC method SQLSetStmtAttr is called with the option SQL_ATTR_ENLIST_IN_DTC.