Hi,

I am trying to use XA driver ( two phase commit) in my app server but getti
ng "Unable to get a XAConnection from the DataSource. exception" exception:

c740c74 FreePool E J2CA0046E: Method createManagedConnctionWithMCWrappe
r caught an exception during creation of the ManagedConnection for resource
jdbc/TeraSolve_SQL, throwing ResourceAllocationException. Original exceptio
n: com.ibm.ws.exception.WsException: DSRA8100E: Unable to get a XAConnection
 from the DataSource.


which followed by "Could not find stored procedure 'master..xp_jdbc_open'."
exception :

[5/26/04 13:55:56:899 NZST] c740c74 SystemErr R com.dss.server.DSSException: [IBM][SQLServer JD
BC Driver][SQLServer]Could not find stored procedure 'master..xp_jdbc_open'.


I am using "WebSphere embedded ConnectJDBC driver for MS SQL Server (XA)"
that shipped with WebSphere and it uses sqlserver.jar,base.jar,util.jar and
spy.jar.

I am new to this stuff and would appreciate any help to fix this problem.


Thanks

Dhafir