by rg400005 » Wed Jun 10, 2015 7:46 am
Hello Richard,
thx for your kind offer.
Sometimes is good to rethink and act different.
Here is my solution, which saves me for setting up and maintaining a server structure.
As I don't have many concurrent users, and the most of them do only read only queries, this solution fits best for me.
1. Keep the foxpro DBFS. This also save to install client connectors ( odbc) on every ws or to rewrite my fat client app.
2. Put them on a network space and share it.
3. Deploy the app local with runtime but keep reports, data, etc. (office templates) remote on the share
4. VFP can do UNC-Path, but for avoiding nameservers I have a machine with a fixed ip address.
5. Setup DBFDir and SearchDir in Appdata to //FixedIP-Adress/Datapath of share.
4 hrs thinking, 15 min for realizing. But this saves me a lot of work and infrastructure.
But for sure, this is a doesn't fit for all solution, and with concurrent read and write a real db server will make live much easier, but you have to keep in mind, to install a client connector for every workstation or write a web app or us a terminal server solution...
BR
Rainer
Update 06/11/15
Now I have also a solution which saves me of producing web pages and even have a push notification and connection to my groupware tool.
- RSS Feed
Write some XML and put into into a webserver script.
Instead of pushing the complete table
there is a info and a item part.
(see rss doku)
In the item part (which is one record) I have link to a remote method of my webpage which then produces the info on the fly as a html page, which now can be saved stored or whatever.
example ( replace the x in column 1 with <
[list]
x?xml version="1.0" encoding="utf-8" ?>
- xrss version="2.0">
- xchannel>
xtitle>sample title</title>
xlink />
xdescription>sample description</description>
xlastBuildDate>date of last update of the dbf</lastBuildDate>
- xitem>
xtitle>sample title for the user / I build a string of some fields here in on line</title>
xdescription>description some show it or not </description>
xlink>the link to my server to call the webpage with params which does the query and returns the data</link>
xpubDate>last update of this record</pubDate>
x/item>
x/channel>
x/rss>
[/list]
Publish the link to the file, my groupware tool has a rss plugin, you can also use it with a newsreader, office,...