INFO: OLEDB Provider Support For ITransactionLocal and ITransactionJoin

ID: Q221071

The information in this article applies to:

Microsoft OLE DB, version 2.0

SUMMARY

The following table summarizes the support for ITransactionLocal and ITransactionJoin interfaces for current versions of OLEDB providers supplied or produced by Microsoft. This information is useful when you are working with an OLEDB provider inside Microsoft Transaction Server (MTS) transactions or with SQL Server 7.0 distributed queries.

Providers ITransactionLocal ITransactionJoin

SQL Server Yes Yes

Oracle Yes Yes

Jet 4.0 Yes No

OLE DB Provider for ODBC Depends on ODBC Driver Depends on ODBC Driver

Index Server No No

Visual C++ ATL Default Provider No No

Providers	ITransactionLocal	ITransactionJoin
SQL Server	Yes	Yes
Oracle	Yes	Yes
Jet 4.0	Yes	No
OLE DB Provider for ODBC	Depends on ODBC Driver	Depends on ODBC Driver
Index Server	No	No
Visual C++ ATL Default Provider	No	No

MORE INFORMATION

ITransactionLocal is used for handling local transactions; that is, for example, starting a transaction, committing, and aborting, while ITransactionJoin is used for enlisting a transaction in a distributed transaction.

REFERENCES

For more information on OLEDB providers refer to the documentation on DASDK and MSDN.

Additional query words:


Keywords          : kbole kbDatabase kbOLEDB kbProvider 
Version           : WINDOWS:2.0
Platform          : WINDOWS 
Issue type        : kbinfo

Last Reviewed: April 9, 1999