Article View: borland.public.cppbuilder.database.ado
Article #1798ADO Access database, and multiusers. Again
From: Stefano
Date: Thu, 29 Jan 2004 11:31
Date: Thu, 29 Jan 2004 11:31
33 lines
2085 bytes
2085 bytes
Hi all, after many question, and thanks to the people that have show the right way, I've just modified the ADOConnection Properties with : Jet OLEDB:Flush Transaction Timeout = 2000 and Jet OLEDB:Shared Async Delay = 2000 What I need to do is to access the same file database from 2 or more instance of the same application, and to SYNC all the edit/insert/delete operation to all clients. I use ADOConnection, ADODataSet, ADODataSource and a DBGrid (I use this just as a test form), and a client-side cursor, just because I need to get a SELECT result set. I've set the cmShareDenyNone in the ADOConnection->Mode property. How can I trig all the users database operations ? When I try with this sample application I've monitored all the component events with breakpoint, but if I do any DB edit/delete/insert operation nothing appen on the other application connected to same database file. What is wrong ? Do I've to use an ADORDSConnection component instead of normal ADOConnection ? Thank's to anyone tha can help me. Steve
Technical Details
Message-ID:
<4018d307@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!newsfeed2.dallas1.level3.net!news.level3.com!crtntx1-snh1.gtei.net!chcgil2-snh1.gtei.net!news.bbnplanet.com!nycmny1-snf1.gtei.net!news.gtei.net!colt.net!peernews3.colt.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,f3560462f9154d98,start X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2004-01-29 01:39:30 PST From: "Stefano" <p.bianchi@tin.it> Newsgroups: borland.public.cppbuilder.database.ado Subject: ADO Access database, and multiusers. Again Date: Thu, 29 Jan 2004 10:31:25 -0100 Lines: 38 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 NNTP-Posting-Host: 62.211.167.170 Message-ID: <4018d307@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1075368711 62.211.167.170 (29 Jan 2004 01:31:51 -0700) Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!newsfeed2.dallas1.level3.net!news.level3.com!crtntx1-snh1.gtei.net!chcgil2-snh1.gtei.net!news.bbnplanet.com!nycmny1-snf1.gtei.net!news.gtei.net!colt.net!peernews3.colt.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail