ODBC connection to PostgreSQL

Поиск
Список
Период
Сортировка
Искать

ODBC connection to PostgreSQL

От:
"Christian Marschalek" <cm@chello.at>
Дата:
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

От:
Oliver Vecernik <vecernik@aon.at>
Дата:
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

От:
Stefan Huber <schweinsaug@crosswinds.net>
Дата:

>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

От:
"Christian Marschalek" <cm@chello.at>
Дата:
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)
> 

FAQ