Bert2005
asked on
What is the best way to install server-client applications?
OK, none of my tech buddies can give me a straight answer to this question. And, the scenario comes up with each new version of the program. I am not even sure if this program is the definition of a server-client application.
We have a local area network all running Windows XP Professional with a SBS 2003 R2 server. The most important daily application is our electronic medical record. I generally install it by installing the program on each computer and then installing it on the server. When the program is run for the first time, it asks what database you wish to use, i.e. the local one or to browse to the database on the server. Obviously, we choose to use the database on the server. So, in this setup, each user is using the software program on his or her desktop and accessing the database on the server. FYI: the database is Microsoft Access and while the full program does not have to be on the server in order for this configuration to run, the Access database does have to be in the EMR folder on our database D: drive to work as the database.
The other way to set it up, which we have not done, would be to run it like our office management software is designed to run. Install the full program on the server and share out the executable file, copying it to each desktop. This does have the advantage of making up grades much easier. I have at least tried it on one machine that way and cannot tell any speed differences.
Is either way better than another? All server applications intended to be run in the latter configuration?
Thanks.
We have a local area network all running Windows XP Professional with a SBS 2003 R2 server. The most important daily application is our electronic medical record. I generally install it by installing the program on each computer and then installing it on the server. When the program is run for the first time, it asks what database you wish to use, i.e. the local one or to browse to the database on the server. Obviously, we choose to use the database on the server. So, in this setup, each user is using the software program on his or her desktop and accessing the database on the server. FYI: the database is Microsoft Access and while the full program does not have to be on the server in order for this configuration to run, the Access database does have to be in the EMR folder on our database D: drive to work as the database.
The other way to set it up, which we have not done, would be to run it like our office management software is designed to run. Install the full program on the server and share out the executable file, copying it to each desktop. This does have the advantage of making up grades much easier. I have at least tried it on one machine that way and cannot tell any speed differences.
Is either way better than another? All server applications intended to be run in the latter configuration?
Thanks.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Not opposing...if the site recommends it - then I'd certainly go that route. I agree with leew - go with what the vendor suggests...especially if it's an app that contains sensitive data! :^)
ASKER
While leew's answer is the perfect answer for my application, I feel it is only right to reward sirbounty as well. Mainly, because it lets me know that the other way is a viable possibility for some apps, and because he was very helpful as well. I have a very difficult time not rewarding those that give good input, plus I know that you are not only in it to get points but to help.
Thanks.
Thanks.
"plus I know that you are not only in it to get points but to help"
I don't know what you're talking about...I'm only here for the points...haha!
Just kidding of course - I think you'll find most of the 'real' experts are here because they like the challenges presented and they love helping others. The 'contest' to be the best is a nice add-in, and I think what makes this site so exceptionally addictive!
Glad I could offer some assistance here. Best of luck to you.
~sirbounty
I don't know what you're talking about...I'm only here for the points...haha!
Just kidding of course - I think you'll find most of the 'real' experts are here because they like the challenges presented and they love helping others. The 'contest' to be the best is a nice add-in, and I think what makes this site so exceptionally addictive!
Glad I could offer some assistance here. Best of luck to you.
~sirbounty
ASKER
Thanks. I am sure I will run into you again on another question.
ASKER
Leew, I agree about SQL Server. I have advised that many times. I think Microsoft even makes a free version. The entire software was made by a physician who had never even heard of Visual Basic six years ago so there is a lot of code which could be better.
So, what do you think. Based on his recommendations, do you both think I should go with the loading it on the clients as well?
http://www.amazingcharts.com/demo/index.htm