>>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.
You can also use ODBC Manager to create a file DSN and than open it in any text editor and copy connection string out.