1. According to Q193893, we need to build two views in Oracle.
Information About Using Oracle with Microsoft Transaction Server and Com Components
http://support.microsoft.com/?id=193893
Based on our past experience, we can try to run Oracle's own scripts with the SYS account. The default path for the script is:
C: /oracle/ora92/rdbms/admin/xaview.sql
Please run the script in SQL Plus.
2. The above command will establish two views. We also need to manually add PUBLIC permissions to these two newly created views:
SQL> Grant SELECT ON V $ xatrans $ to public with grant option;
SQL> Grant SELECT ON V $ Pending_xatrans $ to public with grant option;
SQL> GRANT SELECT ANY TABLE TO PUBLIC;
The above operation is carried out on the computer where the Oracle database is located. The following operation is to perform on the computer deploying the COM component:
1. According to Q193893, we need to modify the registry:
HKEY_LOCAL_MACHINE / SOFTWARE / Microsoft / MSDTC / MTXOCI
"OracleXalib" = "Oraclient9.dll"
"Oraclesqllib" = "ORASQL9.DLL"
"Oracleocilib" = "OCI.dll"
If it is Windows 2003 or Windows XP2, we also need to build:
HKEY_LOCAL_MACHINE / SOFTWARE / Microsoft / MSDTC / XADLL
Then add the name as:
The string key of MTXoci.dll, the content is:
C: /windows/system32/mtxoci.dll
2. If you are on Windows 2003 or Windows XP, we need to set the corresponding permissions to the MSDTC account. MSDTC runs under the Network Service account. Please add the NetWork Service account to the Administrators group.
