Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Setting up Postgre ODBC?
Message
 
To
27/03/2003 18:59:42
Liam O'Hagan
O'Hagan Programming Ltd
Ireland
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00770795
Message ID:
00771113
Views:
19
I'm using WebMin to set up and administer these things - what startup file would contain this command on the Linux box?

>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
Kogo Michael Hogan

"Pinky, are you pondering what I'm pondering?"
I think so Brain, but "Snowball for Windows"?

Ideate Web Site
Previous
Reply
Map
View

Click here to load this message in the networking platform