Failed to initialize DTC, or Test Connection button fails, for Data Source connecting to Microsoft SQL Server version 7.0
 Technote (troubleshooting)
 
Problem(Abstract)
The connection to Microsoft® SQL Server 7.0 fails after clicking Test Connection from the data source configuration panels in the WebSphere® Application Server administrative console.
 
Cause
Microsoft SQL Server 7.0 does not support 2-Phase Commit or XA transactions. The WebSphere Application Server Test Connection uses the XADataSource.getConnection to obtain the connection to the database.
 
Resolving the problem
Make sure that the data source is configured with the custom property disable2Phase set to true to disable 2-Phase Commit. The Test Connection button still fails, but the application can use the data source without error.
 
 
Cross Reference information
Segment Product Component Platform Version Edition
Application Servers Runtimes for Java Technology Java SDK
 
 


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server > Java 2 Connectivity (J2C)
Operating system(s): Windows
Software version: 5.1
Software edition:
Reference #: 1109911
IBM Group: Software Group
Modified date: Jul 13, 2004