Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 7 of 7 total |
Shared FS/CS database |
Fri, Feb 20 2009 4:31 PM | Permanent Link |
Rob Fletcher | Is it recommended to share a database with FS and CS users simultaneously? If so then
what pathname strategy should be used for the database and where should the config file be located? Sorry if this has been answered but i couldn't find it. |
Fri, Feb 20 2009 6:47 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Rob,
<< Is it recommended to share a database with FS and CS users simultaneously? >> Only if the the Local users are accessing via the same machine, such as the case with a web application or terminal services. If the Local users are accessing via a different machine, then you're effectively defeating most of the benefits of using C/S access in the first place. Perhaps you could give me an idea of your requirements. There may be a different way to structure things. -- Tim Young Elevate Software www.elevatesoft.com |
Fri, Feb 20 2009 9:39 PM | Permanent Link |
Rob Fletcher | Tim,
Maybe a better question is there a way to prevent FS and CS users from accessing the same database? In my application I give the user a setup screen with the option of single user or multi user. If they choose single user then I create a database using a path such as (EXEPath)+'\Data\'. If they choose CS then I ask them for the IP address, loginid, password, connect to server, create the database if needed. What is to prevent a rouge user from running my program and choosing single user mode even though other users are currently using CS mode? Is there any way to lock them out while CS users are active? Rob "Tim Young [Elevate Software]" wrote: Rob, << Is it recommended to share a database with FS and CS users simultaneously? >> Only if the the Local users are accessing via the same machine, such as the case with a web application or terminal services. If the Local users are accessing via a different machine, then you're effectively defeating most of the benefits of using C/S access in the first place. Perhaps you could give me an idea of your requirements. There may be a different way to structure things. -- Tim Young Elevate Software www.elevatesoft.com |
Sun, Feb 22 2009 6:12 PM | Permanent Link |
Dale Derix | Rob Fletcher wrote:
<< What is to prevent a rouge > user from running my program and choosing single user mode even though other users are > currently using CS mode? >> How about if they want to run as a single user, have them enter the ip as 127.0.0.1 or host as "localhost". Then they would still be using C/S, wouldn't they? Its just that both the client and server are running on the same machine. Dale |
Mon, Feb 23 2009 9:07 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Rob,
<< Maybe a better question is there a way to prevent FS and CS users from accessing the same database? >> The only surefire way is to prevent FS users from accessing the data directly, i.e. sequester the data on the server machine and don't make the applicable directories be shareable resources. << In my application I give the user a setup screen with the option of single user or multi user. If they choose single user then I create a database using a path such as (EXEPath)+'\Data\'. If they choose CS then I ask them for the IP address, loginid, password, connect to server, create the database if needed. What is to prevent a rouge user from running my program and choosing single user mode even though other users are currently using CS mode? Is there any way to lock them out while CS users are active? >> There really isn't any foolproof way to prevent them from doing so other than the above. However, if they already have control over what is shared, etc., then they can still get around any access restrictions by simply changing them. -- Tim Young Elevate Software www.elevatesoft.com |
Wed, Feb 25 2009 1:29 AM | Permanent Link |
Rob Fletcher | If simultaneous FS and CS access to a database is not recommended then why doesn't the
server open the files exclusively? Rob "Tim Young [Elevate Software]" wrote: Rob, << Maybe a better question is there a way to prevent FS and CS users from accessing the same database? >> The only surefire way is to prevent FS users from accessing the data directly, i.e. sequester the data on the server machine and don't make the applicable directories be shareable resources. << In my application I give the user a setup screen with the option of single user or multi user. If they choose single user then I create a database using a path such as (EXEPath)+'\Data\'. If they choose CS then I ask them for the IP address, loginid, password, connect to server, create the database if needed. What is to prevent a rouge user from running my program and choosing single user mode even though other users are currently using CS mode? Is there any way to lock them out while CS users are active? >> There really isn't any foolproof way to prevent them from doing so other than the above. However, if they already have control over what is shared, etc., then they can still get around any access restrictions by simply changing them. -- Tim Young Elevate Software www.elevatesoft.com |
Wed, Feb 25 2009 9:44 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Rob,
<< If simultaneous FS and CS access to a database is not recommended then why doesn't the server open the files exclusively? >> Web apps, and other local applications that run directly on the server machine. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Wednesday, June 12, 2024 at 01:54 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |