To use two-phase commit with ASE servers
Connect to an ASE.
Add an external login entry for the DirectConnect server for the “probe” login which is used to recover two-phase commit transactions. The Oracle login that is used must have the necessary privileges to recover transactions for any user.
For example:
sp_addexternlogin dco_server, probe, system, manager
Configure the DirectConnect server to use two phase commit.
For example:
dco_server...sp_configure dco-server, two_phase_commit, 1
Shut down and restart the DirectConnect server.
Shut down and restart the ASE.