Re: Sharing a ADO connection between two processes - Can it be done ?

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

On 2 Oct 2006 07:38:35 -0700, "Herby" <prmarjoram@xxxxxxxxx> wrote:


¤ But the problem is the two do not share a common data access layer.
¤ Although, agreed, they should from a well designed perspective. But
¤ this is old code and a complete rewrite to support this is not viable
¤ at present.
¤
¤ Both point to the same underlying DBMS and share the same data.
¤
¤ So currently the client does some work, then calls the server, the
¤ server does some work.
¤ The client then decides to rollback. Problem the servers changes
¤ remain committed.
¤
¤ Are you saying its impossible for two processes on the same machine to
¤ participate in the same
¤ transaction via ADO?

Yes.

¤ Im just assuming in order to participate in the same transaction they
¤ need to share the same connection object?
¤

Yes but ADO transaction processing is an in-process implementation.

¤
¤ Moving to COM+ - Can you recommend and article to read up on that could
¤ support this requirement?

The following article should provide for an overview. However, I would recommend looking for a book
that documents the actual implementation. One book I've used is Programming Distributed Applications
with COM+ and Visual Basic 6.0 by Ted Pattison. The Scot Hillier books are good as well.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dncomser/html/complus4vb.asp

http://www.amazon.com/Hillier-COM+-Programming-Visual-Basic/dp/067231973X
http://www.amazon.com/Programming-Distributed-Applications-Microsoft-Visual/dp/073561010X
http://www.amazon.com/Programming-Visual-Basic-Jose-Mojica/dp/1565928407


Paul
~~~~
Microsoft MVP (Visual Basic)
.

Relevant Pages