Hi All
I have several POS programs (Windows forms VS 2005)
Some customers have multiple copies of the programs, all networked to the 1
SQL Server 2005 Database which resides on 1 of the computers
The programs do auto updating from my website, where they download any new
updates and the update program runs on the next restart of the computer
Problem
If computer 1 (with Sql server) gets updated and computer 2 hasn't updated
yet, then if any Database table or field changes have been made in the
update then computer 2 may generate errors when connecting to SQL server if
it is getting data from any table where the Table field names etc may have
changed
If computer 2 (without Sql server) gets updated and computer 1 hasn't
updated yet, then if any Database table or field changes have been made in
the update, then computer 2 will generate errors when connecting to SQL
server as it will try to reference database tables and fields which may not
exist yet
What is the recommended strategy for synchronising program updates in multi
user environments?
Regards
Steve
2  1358 
"Steve" <ga*****@nospam .nospamwrote in
news:OW******** ******@TK2MSFTN GP04.phx.gbl:
Problem
If computer 1 (with Sql server) gets updated and computer 2 hasn't
updated yet, then if any Database table or field changes have been
made in the update then computer 2 may generate errors when connecting
to SQL server if it is getting data from any table where the Table
field names etc may have changed
For this sort of application, it's a bad idea to connect directly to SQL
server. You should implement some sort of data access layer and business
logic layer which is somewhat loosely coupled. A web service is perfect
for this... the web service could accept a POS request object, if
certain fields are missing, the web service can return with a graceful
exception for the client to swollow.
What is the recommended strategy for synchronising program updates in
multi user environments?
Definately front the database with a webservice or similar facade. It'll
provider greater security than directly connecting to the database and
allow you to run your clients across the internet.
Use a deployment tool such as ClickOnce to do automatic updates.
However, my experience with ClickOnce hasn't been exactly positive, but
others in this group seem to like it.
-- sp**********@ro gers.com (Do not e-mail)
Steve wrote:
Hi All
I have several POS programs (Windows forms VS 2005)
Some customers have multiple copies of the programs, all networked to the 1
SQL Server 2005 Database which resides on 1 of the computers
The programs do auto updating from my website, where they download any new
updates and the update program runs on the next restart of the computer
Write a small routine which checks for updates when your program starts,
before any attempt is made to access data. If it finds an update,
advise the User (via a pop-up or whatever) then commence the download of
the update. At the end of the update, re-start the application.
Problem
If computer 1 (with Sql server) gets updated and computer 2 hasn't updated
yet, then if any Database table or field changes have been made in the
update then computer 2 may generate errors when connecting to SQL server if
it is getting data from any table where the Table field names etc may have
changed
As I "Roll-my-own" databases and don't rely on slow interfaces to such
things as SQL and alike, I incorporate a byte-value at the beginning of
every database which contains a Version Number. You could probably
emulate this by having a single file which every computer reads, before
connecting to your SQL database, and if the value in this file is
greater than a constant value set in the program then it advises the
User that their program is an "old" version and initiates an Update
routine or whatever. If the value in the file is lower, then the
program updates the value to indicate a newer program version.
Works for me!
ShaneO
There are 10 kinds of people - Those who understand Binary and those who
don't. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Sergio |
last post by:
Hi everybody,
I have the following scenario. Several computers with shared disk in a
LAN. Each of these computer has a MySQL server that serves several
databases. I have several clients that communicate with a Java process
that I have in each computer to answer queries for a given database
(it connects to the MySQL server). I also have a Java process that
updates continuously the databases; this process executes only in the
local...
|
by: Xah Lee |
last post by:
What is Expresiveness in a Computer Language
20050207, Xah Lee.
In languages human or computer, there's a notion of expressiveness.
English for example, is very expressive in manifestation, witness all
the poetry and implications and allusions and connotations and
dictions. There are a myriad ways to say one thing, fuzzy and warm and
all. But when we look at what things it can say, its power of
|
by: Chris Baker |
last post by:
This is a problem I have been troubleshooting for about 4-6 months. I
have an e-mail form on a client's public website that is mis-behaving.
It is written in ASP and uses a CDO.Message object. there is only one
call to the Send method. The problem occurs with and also without a
CDO.Configuration set to the Message.
When I test the form from my computer, it acts normally, sending only
one message, and I receive only one message;...
|
by: Xah Lee |
last post by:
The Concepts and Confusions of Pre-fix, In-fix, Post-fix and Fully
Functional Notations
Xah Lee, 2006-03-15
Let me summarize: The LISP notation, is a functional notation, and is
not a so-called pre-fix notation or algebraic notation.
Algebraic notations have the concept of operators, meaning, symbols
placed around arguments. In algebraic in-fix notation, different
|
by: Xah Lee |
last post by:
The Nature of the “Unix Philosophy”
Xah Lee, 2006-05
In the computing industry, especially among unix community, we often
hear that there's a “Unix Philosophy”. In this essay, i dissect the
nature and characterization of such “unix philosophy”, as have been
described by Brian Kernighan, Rob Pike, Dennis Ritchie, Ken Thompson,
and Richard P Gabriel et al, and in recent years by Eric Raymond.
| | |
by: kirby.urner |
last post by:
Cyber-curricula have a leveling aspect, as kids
nearer Katrina's epicenter tune in and bliss out
on 'Warriors of the Net' (why wait for stupid big
dummy textbooks to catch up?). They feel more
empowered by Python and Ubuntu than by any
King's English I'd warrant, given how the latter
has been dumbed down (slowed, degraded) by
unimaginative bankers who can't fathom open
source and its math-teaching significance to
our digitally savvy...
|
by: GregG |
last post by:
Greetings,
I've inherited a project which requires the use of multiple Access
databases, each containing a dozen or so tables each.
I need to perform queries which included relations and results from
the contents of tables from separate databases.
I've got the table adapters configured in the XSDs, connection strings
in the web.config, and use data objects in the site's code, but for
the life of me I cannot figure out how to...
|
by: chimambo |
last post by:
Hi All,
I have a little problem. I am retrieving records from a table and I
want to update the records using checkboxes. I am able to display the
database record quite alright and I have created an array of
checkboxes, but my update loop is not working. Here is my code:
/*---------This retrieves the records -------------*/
if($row_md)
{
do{
echo "<tr><td text align='right'>";
|
by: thetaamommy |
last post by:
Hi All :
CREATE TABLE TABLEA(Person Varchar(20), Country Varchar(20), Subject
Varchar(20), Type Char(1))
INSERT INTO TABLEA VALUES ('Einstein', 'Germany', 'Physics', 'P')
INSERT INTO TABLEA VALUES ('Kant', 'Germany', 'Philosophy', 'Q')
INSERT INTO TABLEA VALUES ('Kafka', 'Germany', 'Writer' , 'W')
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, well explore What is ONU, What Is Router, ONU & Routers main usage, and What is the difference between ONU and Router. Lets take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupr who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
