I am running Postgres on Redhat Linux 9. I am on a Windows2000 server and can run PGADMINIII without problems however I cannot get a connect string to work from inside VFP7. I modifed the example that Leland gave earlier in this thread and it doesn't work. I pinged the server and it responds fine. Any ideas?

mystring="DATABASE=OWL;SERVER=192.168.100.17; port=5432;UID=margaretgi;pwd=mypass;provider=MSDASQLR;DRIVER=postgreSQL;"

oConnection=SQLSTRINGCONNECT(mystring)

results are -1