Hi All,
I have written a VFP front-end client to a postgres backend database. I am making it freely available to anyone that would like to see what client/server computing over the Internet is all about. All source code is available. To use the VFP front-end client you must:
1) Download the VFP Front End Client. It can be found at:
2) Have VFP 7 installed on your computer. This is necessary because VFP 7 has converted the menus so they will not work with earlier version of VFP.
3) You would need the postgress ODBC driver. It can be found at:
This driver needs to be downloaded and installed.
4) You must configure a Data Source ODBC driver as follows:
Data Source: PostgreSQL
Database: vfp2pg
Server: port: 5432
User Name: VfP2Pg
Password: HelloWorld
Although the particular VFP7 front-end client I wrote is programmed to connect to a postgres database, it can be easily modified to work with about any backend including MSSQL, MySQL, mSQL, DB2, Oracle, Sybase, and probably many other as long as the database server has an ODBC driver.
I have the postgres database already set up and ready to go on my Red Hat Linux 7.1 web server, so all you have to do is follow the instructions above to connect to it and add, delete, and update records. The postgres database server is a computer with an ADM 500 MZ CPU, 256 meg of memory, and a 60 gig hard drive. The postgres database is strictly for testing/demo purposes so feel freee to experiment with it.
This is provided in response to the many request for real world examples, including source code, about how to use a VFP Front End client to access an enterprise class backend database server.
I want to particularly thank Ramani for the example in the FAQ about how to create a grid that highlights the grid row on which the record pointer rest of the grid's record source.
Enjoy,
Leland Jackson, CPA
Leland F. Jackson, CPA
Software - Master (TM)
Nothing Runs Like the Fox
I have written a VFP front-end client to a postgres backend database. I am making it freely available to anyone that would like to see what client/server computing over the Internet is all about. All source code is available. To use the VFP front-end client you must:
1) Download the VFP Front End Client. It can be found at:
2) Have VFP 7 installed on your computer. This is necessary because VFP 7 has converted the menus so they will not work with earlier version of VFP.
3) You would need the postgress ODBC driver. It can be found at:
This driver needs to be downloaded and installed.
4) You must configure a Data Source ODBC driver as follows:
Data Source: PostgreSQL
Database: vfp2pg
Server: port: 5432
User Name: VfP2Pg
Password: HelloWorld
Although the particular VFP7 front-end client I wrote is programmed to connect to a postgres database, it can be easily modified to work with about any backend including MSSQL, MySQL, mSQL, DB2, Oracle, Sybase, and probably many other as long as the database server has an ODBC driver.
I have the postgres database already set up and ready to go on my Red Hat Linux 7.1 web server, so all you have to do is follow the instructions above to connect to it and add, delete, and update records. The postgres database server is a computer with an ADM 500 MZ CPU, 256 meg of memory, and a 60 gig hard drive. The postgres database is strictly for testing/demo purposes so feel freee to experiment with it.
This is provided in response to the many request for real world examples, including source code, about how to use a VFP Front End client to access an enterprise class backend database server.
I want to particularly thank Ramani for the example in the FAQ about how to create a grid that highlights the grid row on which the record pointer rest of the grid's record source.
Enjoy,
Leland Jackson, CPA
Leland F. Jackson, CPA
Software - Master (TM)
Nothing Runs Like the Fox