My Oracle Support Banner

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 to [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.


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



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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.