Solved

SNAP type SAN File Server for Visual FoxPro Database

Posted on 2013-01-10
3
739 Views
Last Modified: 2013-01-12
Hi,

I am interested in a NAS/SAN type file server for Visual FoxPro database files. Thsi woudl not be used fro archives, it would be live data in a well tuned VFP DBC that may have 20 very active concurrent users. In the past we have deployed full M$ Windows servers but I am wondering if we really need the Windows server OS and all the other headaches that go along with it?

Any suggestions?
0
Comment
Question by:BobBrink
3 Comments
 
LVL 24

Expert Comment

by:chaau
ID: 38765586
you do not need a windows server for FoxPro files. Foxpro is not a client-server type of database. It is a file-system database. Basically, any SAMBA-type share would do the trick. You can even keep the database on a Network Disk type of devices, which are currently very cheap
0
 
LVL 41

Expert Comment

by:pcelba
ID: 38766178
NAS devices should work as shared files storage. The obvious problem is Windows compaitiblity in some side areas like file and record locking or oplocks. You may Google FoxPro +oplocks to read more.

You have to test the concurrent data access very cerefully to avoid possible negative surprises...
0
 
LVL 29

Accepted Solution

by:
Olaf Doschke earned 500 total points
ID: 38766220
If you have 20 concurrent users, you typically already use a domain and a windows server merely to have it easier to administrate users. Do you really work in a peer-to-peer network with so many users? We have a company of 5 employees and have a win2008r2 server.

And if you have such a server, you just put your DBC and DBFs there, what's so problematic about a Windows Server?

And if Windows Server is a car, NAS is like a motorcycle or smaller vehicles and SAN is like a truck or larger. In what direction do you really need to go?

Storage Area Network means you have lot's of networked storage servers, with much more capabilities than to add a new network share, network  attached storage merely is such a network share via a small mostly linux based pc serving one or more HDDs.

And you can have your problems with a Linux based NAS, as seen here, for example: http://social.msdn.microsoft.com/Forums/en-US/visualfoxprogeneral/thread/58d0d889-169c-4ff7-a2fc-9bb7e5770983 (not very old).

Turns out the file names can be a root problem, as Windows doesn't allow a file aaa.dbf, when there already is AAA.DBF, but to Linux these are two different file names and files. And that can easily bite you. Eg I simply think of PACK creating new files. IIRC it creates all upper case names, but if the original file is lower case PACK will actually create a secondary file not replacing the original. So, at least you need to make sure you can configure the case sensitivity of the NAS. And as most certainly the file system used will not be FAT nor NTFS, you will most certainly have compatibility problems with locking, even if you can configure the case sensitivity.

Bye, Olaf.
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Patch Management is administrated by page 129 of  the following document:     http://support.dell.com/support/edocs/software/smdmc/11/en/ug/ug.pdf However, there are issues with Patch Management with FTP (for instance, a slow Internet connectio…
Learn about cloud computing and its benefits for small business owners.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now