Re: Simple transaction question ????

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: "Miha Markic" <miha at rthand com>
Date: Tue, 5 Jun 2007 18:21:48 +0200

Are you using .net (ado.net)?
BTW, if you have to manage transaction that spawns a single database then DAO (or whatever database provider technology) is just fine and you should avoid serviced component transactions.

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

"calderara" <calderara@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:FE9D66E5-7E56-48C0-9A00-F56C6489B628@xxxxxxxxxxxxxxxx

Dear all,

I am building a multi tiers application.
I have a remote object hosted by a Windows Service which is charge to store
certain data in an SQL databse. Works great.

After this operation I need to dispatch store data to some other tables. for
that opertaion I need database transaction.
The doubt that I have is , do I have to manage my transaction directly using
DAO or should I go for a serviced Component using automatique transaction ??

Any comments will be appreciate..
PS my databas is not a huge database like you might have for a bank or
market database but still have to manage transactionnal stuff

Regards
serge

Prev by Date: Re: Error when calling the OleDbDataAdapter.Fill() method
Next by Date: Re: Another modifier for the datagridview column.Format() property?
Previous by thread: Refresh a datatable afer an update so that child foreignkeys will be changed if necessary
Next by thread: Re: Simple transaction question ????
Index(es):
- Date
- Thread

Relevant Pages

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)
Re: Help - Timing Logic
... put a trigger on the database table. ... Transaction and Database Locking - look at isolation levels / settings ... Maybe implement a message broker ... ...
(microsoft.public.dotnet.languages.vb)
Re: Help - Timing Logic
... build a trigger on the database .. ... Transaction and Database Locking - look at isolation levels / settings ... If you need to implement a locking mechanism / or / logging mechanism / or / a checking mechanism to avoid duplicate messages caused by multi-threading ... ... message broker gets all the necessary messages or message id's from the database to be sent ... ...
(microsoft.public.dotnet.languages.vb)
Re: Connection types and speeds
... CurrentDb is an interesting beast. ... It creates a new object of type Database, and assigns it to the currently ... RecordsetClone of a form) when a transaction was rolled back, ... they mutilated the dbFailOnError switch for the DAO Execute ...
(microsoft.public.access.queries)
Re: Help - Timing Logic
... put a trigger on the database table. ... Transaction and Database Locking - look at isolation levels / settings ... Maybe implement a message broker ... ...
(microsoft.public.dotnet.languages.vb)