Re: Connect to Postgres 7.4 via ODBC

Add :
host    all    all   10.1.9.15   [your subnet mask number]  trust
in pg_hba.conf file.

have you set the ODBC parameter correctly?
database name, etc..?



On Tue, 14 Dec 2004 16:55:20 -0500, Nadia Kunkov
<nadiak@parkerglobal.com> wrote:
> Hi all,
>
> After wasting about half a day I thought I'd ask you for help.
> I have Fedora Core 3 box that came with postgresql 7.4.6 installed.
> Locally I have no problems connecting to the database and running psql.
> I need to set up an ODBC connection from my Windows box.
> Here is what I've done:
>
> 1.      In postgresql.conf
>                 tcpip_socket = true
> (By the way does this eliminate the need to start postgres with -i option, see item 3 below ?)
>
> 2.      in pg_hba.conf
>
>         local   all     all                     trust
>         host    all     all     10.1.9.0                255.255.255.0   trust
>         host    all     all     127.0.0.1       255.255.255.255 trust
>
> The ip address of the windows box is 10.1.9.15 and ip address of the server is 10.1.9.27
>
> 3.      in /etc/rc.d/init.d/postgresql
>
>         su -l postgres -s /bin/sh -c"/usr/bin/pg_ctl -D $PGDATA -o '-i' -p /usr/bin/postmaster start > /dev/null 2>&1
"</dev/null
> Note, I do have -i option.
>
> 4.  I ran netstat -na | grep 5432  and it tells me that postgres is listening on that port.
>
> Every time I try to connect via ODBC from windows I get an error:
> Could  not connect to the server
> Could not connect to remote socket
>
> I'd appreciate any help.
> Thank you
> NK
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly
>


--
Best Regards,

Frans Gunawan
fransgunawan@gmail.com