SQLOLEDB Errors Selecting SQL*Server Views With Linked Tables Using Generic Connectivity DG4ODBC
(Doc ID 731918.1)
Last updated on FEBRUARY 01, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 10.1.0.2 to 11.2.0.2 [Release 10.1 to 11.2]Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |