ID: Q192681
The information in this article applies to:
Microsoft Distributed Transaction Coordinator(MS DTC) has been enhanced to support IBM DB2 and Informix databases. The enhanced version of MS DTC permits a Microsoft Transaction Server application to access IBM DB2 and Informix databases on Windows NT and many other platforms under distributed transaction control.
IBM has enhanced its DB2 ODBC driver to work with Microsoft Transaction Server. IBM's new DB2 driver fully supports Microsoft Transaction Server including connection pooling and automatic transaction enlistment. It allows Microsoft Transaction Server applications to update IBM DB2 databases on Windows NT, OS/2, AIX, HP/UX, Solaris, AS/400, MVS, OS/390, VM, and VSE platforms. All updates can be performed under distributed transaction protection. This allows updates to IBM DB2 databases to be synchronized with updates to other transaction protected resources including Microsoft SQL Server, Microsoft Message Queue Server, Oracle databases, Informix databases, and the like.
The following IBM platforms are supported:
A transactional Microsoft Transaction Server application on Windows NT can connect to an IBM DB2 database on these platforms over TCP/IP, SNA, NetBIOS (Windows NT and OS/2 only), or SPX/IPX (Windows NT, OS/2, and AIX only).
A transactional Microsoft Transaction Server application on Windows NT that needs to connect to an IBM DB2 database on AS/400, MVS, OS/390, VM, and VSE must use DB2 Connect Enterprise Edition V5 (DB2 Connect EE) and the IBM Communication Server on Windows NT, OS/2, or AIX.
In a future release, IBM plans to make it possible for a Microsoft Transaction Server application running on Windows NT to connect directly to an AS/400 or MVS system over TCP/IP.
http://www.software.ibm.com/data/db2/db2tech/indexsvc.html
NOTE: The preceding URL is not under the control of Microsoft and we make
no warranty regarding its use.
Informix has enhanced its Informix ODBC driver to work with Microsoft Transaction Server. This new driver fully supports Microsoft Transaction Server including connection pooling and automatic transaction enlistment. It allows Microsoft Transaction Server applications to update Informix databases on Windows NT and a variety of UNIX platforms. This allows updates to Informix databases to be synchronized with updates to other transaction protected resources including Microsoft SQL Server, Microsoft Message Queue Server, Oracle databases, IBM DB2 databases, and the like.
This update is available for download on the Microsoft anonymous ftp server:
ftp://ftp.microsoft.com/bussys/distapps/MTS/Public-Fixes/usa/DTC/
You must install this update if you need to access IBM DB2 or Informix databases from MTS components under the protection of MS DTC distributed transactions.
This update can only be applied to systems running MTS 2.0. That is the version of Microsoft Transaction Server that was distributed as part of the NT 4.0 Option Pack release. If you have not yet installed MTS 2.0, you can obtain it from the Microsoft Web site by clicking the Resources link on http://www.microsoft.com/com/.
If you only access Microsoft SQL Server, Oracle, and Microsoft Message Queue Server, you do not need to install this release.
The changes included in this update will also be included in the Windows NT 4.0 Service Pack 4 release. When Service Pack 4 is available, you can install it rather than installing this update.
1. Create an empty temporary directory on your system.
2. Run the self-extracting executable file and type the name of the
temporary directory when prompted to do so. The program will unzip the
following files into the temporary directory.
Adme.dll
Dtccm.dll
Dtcxatm.dll
Enudtc.dll
Msdtcprx.dll
Readme.txt
Xolehlp.dll
3. Ensure that the Microsoft DTC service is stopped. Ensure that any
services which depend upon MS DTC are also stopped including Microsoft
Transaction Server, Microsoft SQL Server, Microsoft Message Queue
Server, and Microsoft COM Transaction Integrator (COMTI). Ensure that
the Windows NT Control Panel is not active.
4. The DLLs that you must replace are all located in the Winnt40\System32
directory. You should first rename the six existing DLLs so that you can
return to them later, if you need to do so.
5. Copy the DLL files listed above to the Winnt40\System32 directory.
6. Register the Adme.dll and Msdtcprx.dll files by running the following
commands from the Winnt\system32 directory at a command prompt:
regsvr32.exe adme.dll
regsvr32.exe msdtcprx.dll
7. Restart the MS DTC service and any other services that depend upon it.
8. Install the appropriate IBM DB2 or Informix software release.
Additional query words: prodtranssrv
Version : WINNT:2.0
Platform : winnt
Hardware : x86
Issue type : kbinfo
Last Reviewed: September 29, 1998