Hi Michael,
Glad to hear that you're up and running now. Setting tcpip_socket to true in the postrgesql.conf file is the same as passing the -i parameter. I didn't know that until I looked it up just now so I got something out of this as well. It's nice when everyone wins!
Regards
Liam
>Liam;
>
>Thanks for the help - Leland suggested the postgresql.conf file "tcpip_socket = true" setting - that was the step I missed!
>
>Michael
>
>>Michael,
>>
>>In addition to the -i argument, you also need to modify the host settings in the pg_hba.conf file. This is in the /var/lib/pgsql/data directory unless you specified otherwise when you issued your initdb command.
>>
>>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