Hi John and Bob,

I had a change to play around with using VFP 7 as a front end client to a postgreSQL back end server. I really like it. I made a simple VFP 7 application that can be download from my web site :

http://www.smvfp.com

All the source code is available. I put it in a ZIP file called smsql.ZIP.
You might want to download it and try it out. You will need the PostgreSQL Win32 Binary Distribution of the ODBC Driver which can be found at:

http://www.us.postgresql.org/

The driver can be found under the "User's Lounge"

I have the database already set up on my web server so you can try it out. I'm running Red Hat 7.1 on a system with a k6 500 mz CPU, 256 meg of memory and a 60 gig hard drive. Only 16 gig is allocated to Red Hat Linux 7.1.

Once you have the ODBC install you should enter the following info into it.

Data Source: PostgreSQL11
Database: vfp2pg
Server: www.smvfp.com
port: 5432
User Name: This is not needed because it's already built into the code.
password: This is not needed because it's already built into the code.

After that you should be able to fire up the application and connect to the test database and insert, delete, and update records.

I have pgAdmin II and cannot make a normal connection with it. I keep getting the follow:

Description: Error while executing the query
ERROR: Attribute 'datlastsysoid' not found

I didn't have any problem at all making an ODBC connection with pgAdmin II, so I went with ODBC for the application. I really am not familiar with the DOCs of postgreSQL and I havn't had time to get into them much. Does anyone have any idea why I would be getting the above error when trying to make a direct connection as opposed to a ODBC connection.