Distributed Transaction Coordinator

From: M. Rajesh (coolrjm_at_yahoo.com)
Date: 06/27/03 

Date: Thu, 26 Jun 2003 22:24:40 -0700

Hi,

I am using a concept found in SQL Server (Linked Server,
OpenQuery and MSDTC) to connect to an external RDBMS
(Oracle) with the OLE-DB Provider.

We are connecting to Oracle Database from SQL Server and
have to do the insertion, Updation and deletion from ASP
Code. We want them to be done in a transaction mode. The
updation of both the RDBMS (Oracle and SQL Server) is done
from an ASP Page.

If we do not use transaction in the ASP Page then it works
fine but if we use transactions then we get the
error "Cannot create new connection because in manual or
distributed transaction mode" What is the solution to use
DTC with SQL Server and Oracle. Can anyone help in this
matter. I went through all the documents on MSDTC but no
solution is available to solve this problem.

Thanks and regards,

M. Rajesh

 

Relevant Pages

  • Re: IOT, memory and transaction time
    ... easily generate it with DBMS_METADATA.GET_DDL if your verison of Oracle ... were pretty consistent no matter how big the table (this transaction ... FOREIGN KEY (versionNo) REFERENCES T_TRANSACTIONS, ... Oracle provides read consistency and SQL Server ...
    (comp.databases.oracle.misc)
  • Re: Database or store to handle 30 Mb/sec and 40,000 inserts/sec
    ... "Writers block readers and readers block writers in SQLServer. ... getting around this fundamental issue and because of it SQL Server ... admitted they can happen in Oracle, I guess Oracle should never been used ... isolation level but you will always disagree because you follow doctorine ...
    (comp.databases.oracle.server)
  • Re: IOT, memory and transaction time
    ... easily generate it with DBMS_METADATA.GET_DDL if your verison of Oracle ... If it was the update statement that references ... FOREIGN KEY (versionNo) REFERENCES T_TRANSACTIONS, ... There are however differences how both products deal with concurrency; in Oracle readers don't get blocked while this may happen in SQL Server. ...
    (comp.databases.oracle.misc)
  • Re: Import problems on Windows Server
    ... XP is fine, so is Vista, like you I use them day in day out, around 12 hours ... a day myself too - laptops and the desktop i'm writing this on. ... I use SQL Server on XP and Vista for writing and demo'ing stuff, ... those are the same problems in the Oracle world. ...
    (comp.databases.oracle.server)
  • Re: command line vs grid control
    ... have Oracle on-site for their line-of-business applications. ... customers that Oracle(all of its products not just the RDBMS) run on ... SQL Server where appropriate. ... Written any shell scripts in Windows to ...
    (comp.databases.oracle.server)