XPost: microsoft.public.mts.programming, microsoft.public.platfo   
   msdk.complus_mts   
   From: cricketwee@hotmail.com   
      
   [posted and mailed]   
      
   Hi Brian,   
      
   I have not "Enabled Network for DTS" on my database server.  This is   
   because we're not using the COM+ on that server, but instead on the   
   Web/App server.   
      
   Also, my transactions are already running fine without enabling network   
   for DTS.  However, the problem still persists and occurs at irregular   
   intervals.   
      
   Upon further investigation by my DBA, we came upon two bug articles in   
   oracle knowledge base that quite closely described our symptoms.  And we   
   too employ transactions in a connection pool that also handles not   
   transactional connections.   
      
   The few Bug Articles are:   
   - Bug No:3427477, dated: 06-FEB-2004 &   
   - Bug No:3610265, dated: 04-MAY-2004 &   
   - Bug No:3554534, dated: 05-APR-2004   
      
   I'm going to try the patch that has been issued by Oracle to address Bug   
   No: 3427477.  Will see how we go with it, keeping in mind the other work   
   arounds that have been suggested by the other articles.  Of course   
   switching off connection pooling is not really an option! ;)   
      
   Thanx for the help you've rendered Brian! Appreciated it.   
      
   CricketWee   
      
   CricketWee  wrote in   
   news:6e5da006b43aaed721befafe263c6932@news.teranews.com:   
      
   > Nope, I don't believe we have DTS installed on the Windows 2003 server.   
   > Will give it a go... ;)   
   >   
   > CricketWee   
   >   
   > "Brian Muth"  wrote in   
   > news:eQx0ywlSEHA.2692@TK2MSFTNGP09.phx.gbl:   
   >   
   >> No. I mean DTS. Distributed Transaction Server. It must be enabled for   
   >> network access under Windows Server 2003. This is in your Add/Remove   
   >> Programs control panel applet under Windows Components, Application   
   >> Server. Make sure the checkbox is checked for Enable Network for DTS   
   >> (IIRC).   
   >>   
   >> Brian   
   >>   
   >> "CricketWee"  wrote in message   
   >> news:811142d99b10d9cf08a8940f078bf07e@news.teranews.com...   
   >>> Do you mean Oracle Services for MTS when you say DTS?   
   >>>   
   >>> I believe I have enabled Oracle Services for MTS on the database   
   >>> server. What puzzles me is that this behaviour is not consistent.   
   >>>   
   >>> Thanx for the advise anyway, will check again.   
   >>>   
   >>> CricketWee   
   >>>   
   >>> "Brian Muth"  wrote in   
   >>> news:uyDHuFlSEHA.3140@tk2msftngp13.phx.gbl:   
   >>>   
   >>> > Have you enabled the DTS to have network access on the Windows 2003   
   >>> > Server? By default it is turned off. This typically causes the   
   >>> > complaint you describe.   
   >>> >   
   >>> > Brian   
   >>> >   
   >>> > "CricketWee"  wrote in message   
   >>> > news:0faf08cbe5a603f792883ea5cdcc3fcb@news.teranews.com...   
   >>> >> I too have the same problem/behaviour when using distributed   
   >>> >> transaction with MS DTC.  More information about my environment:   
   >>> >>   
   >>> >> WebServer:   
   >>> >> - Windows 2000 Advance Server   
   >>> >> - Oracle Data Provider for .NET (9.2.0.4)   
   >>> >> - .NET Framework 1.1   
   >>> >> - COM+   
   >>> >>   
   >>> >> Database:   
   >>> >> - Windows 2003 Standard Edition   
   >>> >> - Oracle Database 9i   
   >>> >>   
   >>> >> Any pointers would be greatly appreciated.   
   >>> >>   
   >>> >> Regards,   
   >>> >> CricketWee   
   >>> >   
   >>> >   
   >>> >   
   >>>   
   >>   
   >>   
   >>   
   >   
   >   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)