I agree with this and add:
We have many clients using our VFP9 SP2 software with DBF files on cloud
servers with MS server 2003-2012 with very good results and the best
performance for more than 4 users of any method we know of (using our
software: about 2 million lines of code and over 100 separate DBF files
- heavy volume) They access using RDP clients from different OS. It will
work with android tablets, but since this is accounting software, we
don't think the screen keyboard is the best for this application, but
that is subjective, YRMV
On 5/13/2016 6:54 AM, Dave Crozier wrote:
George,
Don't even try to run with VFP over either a WAN or wireless as it is far to
slow and when it crashes it will probably end up corrupting the VFP tables. As
Mike so rightly says step up to Client Server (M$SQL server (Free version) or
MySQL (or equivalent). The data transfer requirement is minimal, you will never
have to bother about drop outs or bandwidth and it will simply work.
You can access the server via either SQL Pass Through (SPT) or using Cursor
Adapters (CA's) very easily and once you get your head around disconnected data
sets and 3 tier data layers then it is plain sailing.
The free Microsoft SQL Server Express is more than capable of supporting data
volumes for small businesses and is totally free (as is MySQL) and performance
is excellent.
Changing to Client Server does require a rethink in terms of how you design your Business
Logic in order to separate it from your presentation layer but makes life very simple if
you ever come to change the Data Storage Layer from one server to another. The other
advantage is that you can design your programs/systems to be easily maintained as opposed
to using "standard VFP" where all the layers are contained in one level of
program and changing one aspect normally has a knock-on detrimental effect.
Lots of people on the group are well versed in Client Server technology and
there are excellent resources out there written by very knowledgeable VFP
people.
Ask away on here and you will get virtually limitless advice and help.
Best of luck (not that you will need it!)
One other option you also have of course is to migrate your software onto
FoxInCloud which unfortunately I cannot comment on in terms of ease of transfer
or suitability but it has had some good press and a section that allows you to
see exactly what changes would be required to your existing source code.
Contact Thierry Nivelet who frequents here for details.
Dave
-----Original Message-----
From: ProFox [mailto:[email protected]] On Behalf Of G Gambill
Sent: 13 May 2016 04:25
To: ProFoxTech List <[email protected]>
Subject: DBF Records on a Web Server and EXE on Local Box
Is it possible to read web based DBF records (a limited number of records) on a
local box. Memo fields do not apply such that converting the DBF file to an SQL
might be better.
If I can leave the data as a DBF, how do I do it?
If SQL is better both short term and long term, how do I do that? Best
conversion program and reading Web based SQL from a local box code suggestions?
TIA George
--
Success builds confidence. Failure builds knowledge.
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
