INFO: OLEDB Provider Support For ITransactionLocal and ITransactionJoin

ID: Q221071


The information in this article applies to:


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 

Last Reviewed: April 9, 1999