Re: Transaction with stored procedure

Tech-Archive recommends: Fix windows errors by optimizing your registry

I see...

You could try using linked servers/remote servers to do the updates from one
stored proc, but that can cause more problems.

Here is one approach I used when trying to update two databases, one oracle
and one SQL Server...

I started a transaction (oracle stored procedure) against the one database.
If the transaction succeeded, I executed the (SQL) stored procedure against
the second database. If the second (SQL) transaction succeeded, I commited
the first (oracle) transaction. If it failed I rolled back the transaction.

not sure if this is at all helpful. Unfortunately I no longer have the code
that I used for this either.

"ucasesoftware" <ucasesoftware@xxxxxxxxxx> wrote in message
news:1131048761.767849.204250@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> negative
>
> cause one of the 3 are in another database
>


.

Relevant Pages

  • Re: Recordset.AddNew and the recordset objects data retaining
    ... The statement you make about the individual updates not hitting the database ... to do with the updates being in a transaction but rather on whether you specify ... spill over and the memory starts paging out to disk that concerns me). ...
    (microsoft.public.data.ado)
  • Re: DocumentListener is too slow
    ... changedUpdateall call a single method that does the same, ... matter what the user does to the textfield, it updates my stored data. ... > o Group all remaining outstanding updates each transaction. ... Actually, no database, just POJO's stored in memory. ...
    (comp.lang.java.gui)
  • Code works without Transaction, but not with
    ... With the transaction statements back ... updates do not work. ... the back end, so I created a new back end database, imported the table ... corruption problem, but the transaction still does not work. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Inserts and updated sqlserver
    ... > has its own session to the database. ... > If I do all the inserts and do updates in one thread it works fine. ... the end of it and the transaction is rolled back after the timeout. ...
    (microsoft.public.sqlserver.server)
  • Re: Help - Timing Logic
    ... server application, both of which ran on the same box. ... the client applications and 'lodging' them in the database. ... Another part of the server application was dedicated to retrieving messages ... commit transaction ...
    (microsoft.public.dotnet.languages.vb)