>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)
I use a connection string something like the following, which works for me:
Driver=PostgreSQL;UID=someuserid;PWD=somepassword;Server=somesite.ca;Database=somedb
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up