Re: Distributed Transaction

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Paul Clement (UseAdddressAtEndofMessage_at_swspectrum.com)
Date: 02/09/04 

Date: Mon, 09 Feb 2004 10:37:02 -0600

On Thu, 5 Feb 2004 11:38:01 +0530, "Karthikeyan" <Karthikeyan.Ganesan@isoftplc.com> wrote:

¤ Hi,
¤ Thanks for your infomation.
¤
¤ My req is like this..
¤
¤ I have one SQL Server database and one oracle database....
¤
¤ I want to insert one one record in each database.. with in a transaction
¤ context???
¤
¤ (Note : I have to connection object)
¤ How to do that??
¤
¤ Thanks in advance
¤

Under this scenario I would use two separate transactions, one for SQL Server and one for Oracle. If
the fist operation fails, e.g. SQL Server, then the Oracle update would not be performed. If the
second operation fails, e.g. Oracle, then you would rollback the SQL Server transaction. If both
succeed then commit both transactions.

Paul ~~~ pclement@ameritech.net
Microsoft MVP (Visual Basic)

Relevant Pages

  • Distributed Transaction spanning Oracle and Sql DB in a single package?
    ... Oracle database into a SQL server database. ... so far using the Microsoft ODBC driver for Oracle (had some problems using ... Now I want to put a transaction around it to ensure data integrity. ...
    (microsoft.public.sqlserver.dts)
  • Re: Open DB using OLE DB
    ... I am using both SQL Server and Oracle. ... tried opening the SQL Server database, I use the SQLOLEDB.1 provider. ...
    (microsoft.public.vb.general.discussion)
  • Re: Analysis Services on top of an Oracle DB
    ... a ms access database or sql server database. ... We have great experience with a DWH in Oracle and OLAP cubes in MS ... >> Oracle DB as it is on top of Microsoft SQL Server? ...
    (microsoft.public.sqlserver.olap)
  • Re: Open DB using OLE DB
    ... I am using both SQL Server and Oracle. ... > tried opening the SQL Server database, ... > Here is my code to open SQL Server database: ...
    (microsoft.public.vb.general.discussion)
  • Re: SQL Server 2005 vs Oracle
    ... SQL and Oracle. ... SQL Server one sizes log files to handle the largest transaction and its ...
    (comp.databases.ms-sqlserver)