Michael,
Have you started postmaster with the -i argument? If not, non-local users won't be able to connect.
Regards,
Liam
>Hi, Leland - thanks for the response.
>
>Hmmm... Still getting 'Connectivity Error'. I can ping the Linux box, and I have a user set up. I have allowed all hosts on my internal IP (192.168.1.XXX). I'm using the default port address - what else might I have missed?
>
>TIA
>
>>Hi Michael,
>>
>>I don't use the postgres ODBC even though I have it installed on my system. I use a DSN_less connection like:
>>
>>
>>if is_remote = .T.
>> mystring="DATABASE=vfp2pg;SERVER=68.15.242.97; port=5432;UID=VfP2Pg;pwd=;provider=MSDASQLR;DRIVER=postgreSQL;"
>>else
>> mystring="DATABASE=vfp2pg;SERVER=192.168.1.78; port=5432;UID=VfP2Pg;pwd=;provider=MSDASQLR;DRIVER=postgreSQL;"
>>endif
>>
>>oConnection=SQLSTRINGCONNECT(mystring)
>>
>>
>>I have an example app that can be downloaded from my site that uses a VFP7 front-end to a postgres backend server. The Name of the download is smsql.ZIP. You might take a look at it as something that might help you get started. My site is:
>>
>>
https://www.smvfp.com>>
>>LelandJ
Liam O'Hagan
MCP VFP Desktop Apps