SQLOLEDB Errors Selecting SQL*Server Views With Linked Tables Using Generic Connectivity DG4ODBC
Last updated on JANUARY 19, 2017
Applies to:Oracle Database - Enterprise Edition - Version 10.1.0.2 to 126.96.36.199 [Release 10.1 to 11.2]
Information in this document applies to any platform.
Checked for relevance on 15-Nov-2010
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
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms