Article View: borland.public.cppbuilder.database.multi-tier
Article #395Transactions with multiple Clients
From: AdolfoM
Date: Mon, 08 Apr 2002 19:14
Date: Mon, 08 Apr 2002 19:14
19 lines
1939 bytes
1939 bytes
I have a midas aplication that shares the server among several clientes. And I am trying to use transactions . I created a datamodule with a Database object to do that, however all clients are sharing the same database object, and of course when a client start a Trnsaction (via StartTransaction method of Database), the second one fails, and even worst, all the queries executed by any client are included in the transaction of the only client wirth a transaction open. How can I isolate trnsactions of diferent clients? How can I use a diferent connection to the database for each client? There is some simple way to use a diferent conection for each client? I am using W2K as the application server. Wich runs only one process for each server, no matter how many clients are connected. However other WNT or W2K computers used as server open a diferent proceess of the server for each client? Is that configurable some way? Thanks a lot for any help
Technical Details
Message-ID:
<3cb1ea5c_2@dnews>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!supernews.com!195.40.4.120.MISMATCH!easynet-quince!easynet.net!teaser.fr!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!news.fh-hannover.de!news.uni-stuttgart.de!nntp.cs.uni-magdeburg.de!PeerFeed.KWeb.on.ca!dnewsShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: fcd2b,b4c63bb935807c72,start X-Google-Attributes: gidfcd2b,public X-Google-ArrivalTime: 2002-04-08 12:08:49 PST From: "AdolfoM" <adolfom@e-neotech.com> Newsgroups: borland.public.cppbuilder.database.multi-tier Subject: Transactions with multiple Clients Date: Mon, 8 Apr 2002 14:14:17 -0500 Lines: 25 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 NNTP-Posting-Host: 200.24.77.29 Message-ID: <3cb1ea5c_2@dnews> X-Trace: dnews 1018292828 200.24.77.29 (8 Apr 2002 12:07:08 -0700) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!supernews.com!195.40.4.120.MISMATCH!easynet-quince!easynet.net!teaser.fr!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!news.fh-hannover.de!news.uni-stuttgart.de!nntp.cs.uni-magdeburg.de!PeerFeed.KWeb.on.ca!dnews