= = = Original message = = =
This is an automatically generated Delivery Status Notification.
Delivery to the following recipients failed.
[EMAIL PROTECTED]
============= Inline Message ==============
To: <[EMAIL PROTECTED]>
From: <[EMAIL PROTECTED]>
Date: Fri, 26 Apr 2002 9:57:51 -0400
Subj:
Ok, But the problem is that each server has to read AND THEN
write before the next one reads.
BJ
= = = Original message = = =
> I have 3 computers accessing a SQL-server at the same time.
I
> need the DB to be locked so they can't read/write the data
at
> the same time. How do I get the servers to "get in line" and
> wait for each other?
Almost all databases provide that functionality automatically.
If one
database client is writing to the data, other database clients
won't be able
to read or write that data until the first one is done. If one
database
client is reading the data, other database clients won't be able
to write
that data until the first one is done.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
______________________________________________________________________
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists