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

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