Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP Database in Linux
Message
From
20/12/2002 08:17:30
Liam O'Hagan
O'Hagan Programming Ltd
Ireland
 
 
To
19/12/2002 13:25:51
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00734578
Message ID:
00734836
Views:
11
Hi Fransisco,

Yes, Samba is very stable. There used to be a locking issue with multi-user access to Foxpro tables which is why I stopped using it as a file server for Foxpro tables. As far as I know this has been fixed but I haven't tested it for myself. I do, however, use Samba as a file server for all other purposes and have no problems with it.

If you have 900 users accessing the tables you may wish to consider moving to a database server. There are a number of free DB servers - PostgreSQL and MySQL, to name but two. My preference is for PostgreSQL. Interbase and Firebird were mentioned in another thread. I've used Interbase before on a Windows platform and found it reliable and fast.

Regards,

Liam




>I have a Costumer that wants to look for a less expensive platform to host they VFP databases.
>Now they have their DBF's tables in a Novel Server and the clients, 900 aprox. access them througth WIN 95 in a LAN, and throught Metaframe (thin-cliente) to their WAN.
>The file server crash at least 1 per month (file read error or file write error), because there is only one netware server.
>So, they want to have 3 Netware servers, 300 user per server, but the cost of de licence it's not simple.
>Because of that, I have the simple idea to put their DBF in three Linux server (or two, or one).
>I have been search for information on this, but a prefer to share with you if someone has done this before.
>My experience in Linux is very short... I've seen that there is a software called SAMBA that make a Linux server act like a File Server like Windows NT and is transparent for Windows clients.
>Other cuestion is, if the system is quiet stable.
>
>Wel, I hope you can help me on this.
>
>Thanks.
Liam O'Hagan
MCP VFP Desktop Apps
Previous
Reply
Map
View

Click here to load this message in the networking platform