>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
You can use AERROR() functiom to get ODBC error info which could help in troubleshhoting.
--sb--