Re: Sharing a ADO connection between two processes - Can it be done ?
- From: "Ralph" <nt_consulting64@xxxxxxxxx>
- Date: Mon, 2 Oct 2006 09:35:22 -0500
"Herby" <prmarjoram@xxxxxxxxx> wrote in message
news:1159787669.836583.75730@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
We have a client and server application that run on the same machine.
We want both to participate in the same transaction.
To acheive this I understand they need to share the same connection
object.
The server currently supports a COM interface, as the client passes
across copies of simple data types Strings and integers etc.
But now they want to pass across the client ADO connection object. The
data-writes within the server should then use this connection object
for creating its recordsets etc.
On return to the client - the client may then decide to commit or
rollback via the same connection object.
I understand the server would have a proxy back to the actual
connection object residing in the client address space. Is this going
to work?
It is possible (what in programming isn't?), but I can't imagine a scenerio
where this would be practical. The extra wire traffic alone would likely
slow everything down to a crawl.(An ADO Connection object isn't just a
connection.)
What is it you are really trying to accomplish by doing this?
-ralph
.
- Follow-Ups:
- References:
- Prev by Date: Re: Sharing a ADO connection between two processes - Can it be done ?
- Next by Date: Re: Sharing a ADO connection between two processes - Can it be done ?
- Previous by thread: Re: Sharing a ADO connection between two processes - Can it be done ?
- Next by thread: Re: Sharing a ADO connection between two processes - Can it be done ?
- Index(es):
Relevant Pages
|
