INFO: OLEDB Provider Support For ITransactionLocal and ITransactionJoin (221071)



The information in this article applies to:

  • Microsoft Data Access Components 2.0
  • Microsoft Data Access Components 2.1
  • Microsoft Data Access Components 2.5
  • Microsoft Data Access Components 2.6
  • Microsoft Data Access Components 2.7

This article was previously published under Q221071

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.

ProvidersITransactionLocalITransactionJoin
SQL ServerYesYes
OracleYesYes
Jet 4.0YesNo
OLE DB Provider for ODBCDepends on ODBC DriverDepends on ODBC Driver
Index ServerNoNo
Visual C++ ATL Default ProviderNoNo

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.

Modification Type:MajorLast Reviewed:5/12/2003
Keywords:kbDatabase kbinfo kbProvider KB221071