Thread: ODBC connection to PostgreSQL
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
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
>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."
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) >