🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.ado
Article #1798

ADO Access database, and multiusers. Again

#1798
From: Stefano
Date: Thu, 29 Jan 2004 11:31
33 lines
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-mail

Show 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