Multiple Applications Updating Single Database

Multiple applications updating single database Same app, different PCs, database on server Rate Topic:

#1 Bort

Echo-3 to Carlos Spiceyweiner.

Group: Authors
Posts: 1,549
Joined: 18-September 06

Windows Favorite Browser Favorite Processor Favorite Gaming Platform Your Car
Dream Kudos: 350

Post icon Posted 19 February 2009 - 07:02 AM

I have an application which takes input on a local machine and sends it to a database stored on a server. I'd like to be able to deploy my application over a number of computers (all on the same network), all of them updating the same database (on the network server).

First of all, will this be possible without putting together a completely new application to handle all connections to the database and sorting the entries?

If not, how would I go about doing this?

I have a sneaky suspicion that the concurrency errors from this one are not going to be friendly...

I'm not after all the code or anything, just a point in the right direction

Thanks,
Bort

Was This Post Helpful? 0

Register for Free to Make These Ads Go Away!

#2 modi123_1

Suiter #2

Group: Authors
Posts: 2,099
Joined: 12-June 08

Windows Favorite Browser Favorite Processor Favorite Gaming Platform Your Car
Dream Kudos: 150

Posted 19 February 2009 - 08:35 AM

Yes it is entirely possible. If you have the db server set up then your program needs the right connection string to the server and bam-o.

Our apps usually deal with 2k-5k users a day.

Was This Post Helpful? 0

#3 Bort

Echo-3 to Carlos Spiceyweiner.

Group: Authors
Posts: 1,549
Joined: 18-September 06

Windows Favorite Browser Favorite Processor Favorite Gaming Platform Your Car
Dream Kudos: 350

Posted 19 February 2009 - 08:50 AM

I have a database file stored in shared folders on a server. My program has the correct connection string to connect to it and update it, but won't simply putting my application on multiple PCs will cause concurrency violations?

Was This Post Helpful? 0

#4 baavgai

Dreaming Coder

Group: Expert w/DIC++
Posts: 4,727
Joined: 16-October 07

Linux Favorite Browser Favorite Processor Favorite Gaming Platform Your Car
Dream Kudos: 575
Expert In: C, C++, Java, C#, ASP.NET, PHP, Perl, Python, Oracle, SQL Server, MySql, HTML, JavaScript, Lua, Cheese

Posted 19 February 2009 - 09:58 AM

Bort, on 19 Feb, 2009 - 10:50 AM, said:

I have a database file stored in shared folders on a server....

Sorry, this does not sound like a database...

If the "file" is Access it's time to reconsider your options. If the file is something like one of those MDE thingies Visual Studio embeds, you're probably fine a web app is a single point of entry. If it's just a file you open up on a share then you could be in trouble.

Was This Post Helpful? 0

#5 modi123_1

Suiter #2

Group: Authors
Posts: 2,099
Joined: 12-June 08

Windows Favorite Browser Favorite Processor Favorite Gaming Platform Your Car
Dream Kudos: 150

Posted 19 February 2009 - 11:01 AM

Also I am going to throw this out there - MS SQL express is free and supports a large database.

Baavgai is right.. if this "file" is Access you will have to punt it and get a real DB. MSSQL.. MYSQL... postgre.. something else.

Concurrency issues in what way? as in having twenty people accessing the same piece of data? If that's the case just build a "locking" system that locks that chunk of data from any other user access.

Was This Post Helpful? 0

#6 Bort

Echo-3 to Carlos Spiceyweiner.

Group: Authors
Posts: 1,549
Joined: 18-September 06

Windows Favorite Browser Favorite Processor Favorite Gaming Platform Your Car
Dream Kudos: 350

Posted 20 February 2009 - 01:39 AM

It is an Access database, although I have no problems with changing that to a SQL database instead. Only reason I used Access is because I know how to use Access and have never created a SQL database before.

Concurrency errors as in having 20 people trying to update the same database at the same time, not accessing data.

Was This Post Helpful? 0

#7 Bort

Echo-3 to Carlos Spiceyweiner.

Group: Authors
Posts: 1,549
Joined: 18-September 06

Windows Favorite Browser Favorite Processor Favorite Gaming Platform Your Car
Dream Kudos: 350

Posted 24 February 2009 - 06:20 AM

Can anyone provide me with a download link for SQL Server 2008 Express please?

The one from the Microsoft VS 2008 website is corrupt.

Edit:

Never mind. I found a different Microsoft site where the download seems to be working.

This post has been edited by Bort: 24 February 2009 - 06:27 AM

Was This Post Helpful? 0

#8 DeCompile

D.I.C Regular

Group: Members
Posts: 273
Joined: 20-July 08

Dream Kudos: 0

Posted 24 February 2009 - 05:21 PM

Now this is entirely person opinion and determined by the users of your database.

Personally, we use web apps. Only because there has never been a standard hardware configuration across the multitude of departments that use these applications.

With web apps, there is no installation, no dependancy issues. It's just open a web browser and away you go. Works the same for Apple, Linux, FreeBSD (some users never let go) and even Windoze.

That's my 2c.