Hi Edgar,

I have a web/mail server running RedHat Linux 7.3. I did a full install of RedHat 7.3 which means both the postgres and MySQL database are available by simply enabling the service so it start when the system is booted.

I originally developed a web site with an ISP using MySQL. I switched to postgres about 3 year ago when I moved my web site in-house. Since both postgres and MySQL are SQL 92 compliant, about the only thing I needed to change in the perl web app was one word in the connection string.

I have written a VFP7 frontend client to a postgres backend server. It serves as an example app of how VFP7 can be used to interact with a backend server like MySQL, Postgres, MSSQL, etc. The app can be downloaded from my web site using the link below:

https://www.smvfp.com

You can go to the downloads and select "VFP7 frontend to Postgres backend server" to download smsql.zip.

I supply the postgres database on my web server so you could download the app, install the postgres ODBC driver which is included in smsql.zip, and then connect to my database to see how it works. The example code could be easily adopted to any other database that was SQL 92 compliant. I have recently added an example of using VFP8 cursoradapter to connect to a postgres database. For it, you will need the VFP8 demo installed.

Smsql.zip can also be downloaded here at UT, but I have made some minnor changes to the version available on my web site, so the version avaliable from my web site will be a little more current. Eventually, I will update the UT version.

LelandJ