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: