Thread: ODBC connection to PostgreSQL

ODBC connection to PostgreSQL

From
"Christian Marschalek"
Date:
I installed the PostgreSQL ODBC dll, but everytime I'm trying to connect
to my database server (witch is another machine in my network) I get the
error "Couldn't connect to server, couldn't connect to remote socket"

Now I wonder how I have to configure the postmaster to get this
working...

Telnetting and stuff works without a Problem (even samba) so it's not
the network. In the ODBC Settings the server is my DB Servers IP
(192.168.0.1) user name and database values should be right :)

Any clues?

Thanks! Chris


Re: ODBC connection to PostgreSQL

From
Oliver Vecernik
Date:
Christian Marschalek wrote:
>
> I installed the PostgreSQL ODBC dll, but everytime I'm trying to connect
> to my database server (witch is another machine in my network) I get the
> error "Couldn't connect to server, couldn't connect to remote socket"
>
> Now I wonder how I have to configure the postmaster to get this
> working...
>
> Telnetting and stuff works without a Problem (even samba) so it's not
> the network. In the ODBC Settings the server is my DB Servers IP
> (192.168.0.1) user name and database values should be right :)

You need to configure pg_hba.conf. More information at:


http://www.at.postgresql.org/users-lounge/docs/7.0/admin/security.htm#AEN1345

Hope this helps.

Oliver

Re: ODBC connection to PostgreSQL

From
Stefan Huber
Date:
>Now I wonder how I have to configure the postmaster to get this
>working...

Try starting it with the -i option to tell the postmaster to listen to TCP
Sockets, too.

If it isn't that, you might have a different port, the postmaster is
listening to, or a "misconfigured" firewall/packetfilter.

Stefan
--
Murphy's Laws: "If anything simply cannot go wrong, it will anyway."


RE: ODBC connection to PostgreSQL

From
"Christian Marschalek"
Date:
That helped, thanks!

> -----Original Message-----
> From: pgsql-admin-owner@postgresql.org
> [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Stefan Huber
> Sent: Friday, April 27, 2001 6:32 PM
> To: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] ODBC connection to PostgreSQL
>
>
>
> >Now I wonder how I have to configure the postmaster to get this
> >working...
>
> Try starting it with the -i option to tell the postmaster to
> listen to TCP
> Sockets, too.
>
> If it isn't that, you might have a different port, the postmaster is
> listening to, or a "misconfigured" firewall/packetfilter.
>
> Stefan
> --
> Murphy's Laws: "If anything simply cannot go wrong, it will anyway."
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to
> majordomo@postgresql.org)
>