Vnode Definitions When Using Distributed Transactions through ODBC
For remote Actian X servers, vnodes must be of type Global, not Private, for "Login/password data" and "Connection data" records in the vnode definition. Global definitions are required because portions of MSDTC run under the Windows System account and need the global login and connection data to connect to Actian X for transaction recovery.
If needed, the vnode definition login records must contain the username/password information, not the application connection string, because the username/password information is needed by the MS Transaction Manager and Actian X to connect to the server when XA recovery is needed. Only the vnode information, not the application connection string, is available at that time.
Last modified date: 11/09/2022