I am trying to access an Oracle view via a SQL Server Enterprise Manager 2000 linked server. The linked server connects to the Oracle server fine. I am able to create a successful result set.
When I atempt to save the successful query, the following error message is displayed in SQL Server:
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]The operation could not be performed because the OLE DB provider 'MSDASQL' was unable to begin a distributed transaction.
[Microsoft][ODBC SQL Server Driver][SQL Server][OLE/DB provider returned message:
[Microsoft][ODBC driver for Oracle]Driver not capable]
[Microsoft][ODBC SQL Server Driver][SQL Server]OLE DB error trace [OLE/DB Provider 'MSDASQL'ITransactionJoi JoinTransaction returned 0x8004d00a].