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(at)parkerglobal(dot)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(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>

--
Best Regards,

Frans Gunawan
fransgunawan(at)gmail(dot)com