7. Understanding ODBC Connectivity : Ingres ODBC and Distributed Transactions (Windows) : Vnode Definitions When Using Distributed Transactions through ODBC
 
Share this page                  
Vnode Definitions When Using Distributed Transactions through ODBC
For remote Ingres 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 Ingres 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 Ingres to connect to the server when XA recovery is needed. Only the vnode information, not the application connection string, is available at that time.