 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
.NET Forum / .NET Framework / Component Services / April 2005Transactions with Oracle9i
"Distributed Transactions require Oracle9i client and Oracle Services for Microsoft Transaction Server software." I get the error above when attempt to run a COM+ transaction accessing Oracle9i. I'd been checked the installation of Oracle9i and Oracle Services in the client computer and it is ok. I am using Windows Server 2003 and the database server is on another Windows Server 2003. The database is Oracle9i Enterprise Edition. At Stanford's web site (http://www.stanford.edu/dept/itss/docs/oracle/9i/win.920/a95496/ch1.htm#1079911) I found Oracle's documentation that explains this, but it didn't worked for me. Oracle Services is installed in both machines. The Oracle MTS Recovery Service is running. The COM+ component is registered. When I use the same component with SQL Server 2005 beta 2 it works fine. What else do I need to do? Thanks in advance. Caio Pereira Caio, << "Distributed Transactions require Oracle9i client and Oracle Services for Microsoft Transaction Server software." I get the error above when attempt to run a COM+ transaction accessing Oracle9i. I'd been checked the installation of Oracle9i and Oracle Services in the client computer and it is ok. I am using Windows Server 2003 and the database server is on another Windows Server 2003. The database is Oracle9i Enterprise Edition. At Stanford's web site (http://www.stanford.edu/dept/itss/docs/oracle/9i/win.920/a95496/ch1.htm#107 9911) I found Oracle's documentation that explains this, but it didn't worked for me. Oracle Services is installed in both machines. The Oracle MTS Recovery Service is running. The COM+ component is registered. When I use the same component with SQL Server 2005 beta 2 it works fine. What else do I need to do? Have you checked that both WinServer2003 machines have network transactions enabled?  SignatureTomas Restrepo tomasr@mvps.org http://www.winterdom.com/ Tomas, Do we need to check the transactions in the network server domain or just the database server and client machines? Caio Pereira "Tomas Restrepo (MVP)" <tomasr@mvps.org> wrote in message news:ehgR61MNFHA.3076@tk2msftngp13.phx.gbl... Caio, << "Distributed Transactions require Oracle9i client and Oracle Services for Microsoft Transaction Server software." I get the error above when attempt to run a COM+ transaction accessing Oracle9i. I'd been checked the installation of Oracle9i and Oracle Services in the client computer and it is ok. I am using Windows Server 2003 and the database server is on another Windows Server 2003. The database is Oracle9i Enterprise Edition. At Stanford's web site (http://www.stanford.edu/dept/itss/docs/oracle/9i/win.920/a95496/ch1.htm#107 9911) I found Oracle's documentation that explains this, but it didn't worked for me. Oracle Services is installed in both machines. The Oracle MTS Recovery Service is running. The COM+ component is registered. When I use the same component with SQL Server 2005 beta 2 it works fine. What else do I need to do? >> Have you checked that both WinServer2003 machines have network transactions enabled? -- Tomas Restrepo tomasr@mvps.org http://www.winterdom.com/ << Do we need to check the transactions in the network server domain or just the database server and client machines? Just in the database server and client machine. Note that sometimes I've seen cases where a machine restart has been required for the change to take effect... SignatureTomas Restrepo tomasr@mvps.org http://www.winterdom.com/ Tomas, The DTC and COM+ were disabled in the Oracle database server. We enabled them and then restarted the server, but it is returning the same exception message. Any new ideas? Caio Pereira "Tomas Restrepo (MVP)" <tomasr@mvps.org> wrote in message news:Ol9gCiZNFHA.1096@tk2msftngp13.phx.gbl... << Do we need to check the transactions in the network server domain or just the database server and client machines? >> Just in the database server and client machine. Note that sometimes I've seen cases where a machine restart has been required for the change to take effect... -- Tomas Restrepo tomasr@mvps.org http://www.winterdom.com/ Caio, << The DTC and COM+ were disabled in the Oracle database server. We enabled them and then restarted the server, but it is returning the same exception message. The only thing I can think of is that you have a problem with your Oracle Services for MTS installation on the client machine.... SignatureTomas Restrepo tomasr@mvps.org http://www.winterdom.com/ Free MagazinesGet these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...
|
Reply to this Message
|
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.