Hi and thanks to everyone for your advises.

I’ve used samba on Red Hat 7.2 also and it certainly makes me feel a lot more secure than an NT server.

My point is to use a web server with PHP to access VFP data, since unfortunately local hosting providers have linux servers available, and those with NT based servers don’t seem to like the idea of enabling a VFP-ODBC for you.

I’ve never heard about PHP before until I started to take a Web-Database programming class, and to be honest I immediately fell in love with PHP just like I did with VFP years ago. I’m just amazed at how being an absolute Linux newbie, things work very stable and rather easy. And PHP is usage is growing: www.php.net/usage.php

Good news is that there is a package called nusphere from www.nusphere.com which installs into window’9x or w’2k a complete package (Apache, MySQL, MyODBC, PHP, Perl,. etc.), so you don’t need to try the penguin in order to learn these web technologies.

I’m still a VFP’er and will be. So I’ll make my best in order to stay with the Fox.

Regards and thanks again.

Oscar Corte


>Hi,
>
>When I mentioned a linux file server running samba, what I had in mind was using the standard VFP DBC on a linux file server running samba within a local network. If the topic was about a web server running a linux DBM backend, then my suggestion was off target.
>
>I run a linux web server and have recently moved from MySQL to Postgres. I use the perl DBI called from HTML pages to insert, delete, and update the database. I was able to make the change with very little change to the cgi-bin scripts. If I need to work with the postgres data, I can easily create a comma delimited text file and import it into a VFP table.
>
>Your solution of using a common MySQL or Postgres Datastore, that could be accessed from a web server using perl, PHP, etc, and also be accessed using a VFP application via ODBC within the local network may be a better solution than what I'm currently doing. When I have a little time I plan to play with this an see how it works. By the way I enjoyed your article in Foxtalk "Going Cross-Platform Again: Using Visual FoxPro to Connect to a MySQL Database on Linux".