SQLOLEDB Errors Selecting SQL*Server Views With Linked Tables Using Generic Connectivity DG4ODBC (Doc ID 731918.1)

Last updated on JANUARY 19, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 to 11.2.0.2 [Release 10.1 to 11.2]
Information in this document applies to any platform.
Checked for relevance on 15-Nov-2010


Symptoms

Using Generic Connectivity and Database Gateway for ODBC (DG4ODBC) then SQL*Server tables can be selected successfully.

Selecting from SQL*Server views that have links  to tables on  SQL*Server databases on other machines gives the following error -

[Generic Connectivity Using ODBC][Microsoft][ODBC SQL Server Driver][SQL
Server][OLE/DB provider returned message: New transaction cannot enlist in the specified
transaction coordinator.][Microsoft][ODBC
SQL Server Driver][SQL Server]OLE DB error trace [OLE/DB Provider
'SQLOLEDB' ITransactionJoin::JoinTransaction returned
0x8004d00a].[Microsoft][ODBC SQL Server Driver][SQL Server]The operation could not be performed because the OLE DB provider'SQLOLEDB' does not support distributed transactions.
(SQL State: 37000; SQL Code: 7391)
ORA-02063 : preceding 2 lines from DBLINK

.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms