Thanks for posting this John,
Using VFP with postgresql, is my next project, and getting the connection string working is one of those things which as you found out takes quite a bit of time and research. Since you mention my article, I am sure you understand now that comeing up with the one which works with vfp - mysql was not as simple as it might appear.

Thanks again
Bob lee



>I go it. It turns out that connection string must be in a speical sequence as in
>mystring="DATABASE=acct;SERVER=192.168.1.202; port=5432;UID=root;provider=MSDASQLR;DRIVER=postgreSQL;"
>
>Believe it or not I had to check all the descriptions of the dll drivers to find the name of the ODBC driver = MSDASQLR.dll.
>
>If you change anything it will not work at least with the drivers I downloaded from Postgres.org.
>
>I not sure but I'm guessing that this is not standard.
>
>John