pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedProblems with ODBC connections
4+ messages / 3 participants
[nested] [flat]
* Problems with ODBC connections
@ 2012-02-25 18:05 Sandeep Reddy <deep08u@gmail.com>
2012-02-27 14:17 ` Re: Problems with ODBC connections Adrian Klaver <adrian.klaver@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Sandeep Reddy @ 2012-02-25 18:05 UTC (permalink / raw)
To: pgsql-sql
Hi,
I am completely new to postgres and I have some problems with ODBC
connection.
1) I am running postgres server in Fedora Linux, and I am planning to
connect server from windows client.
2) I have installed 64bit version of postgresql ODBC drivers
3) I am making sure that my postgres is running with -p <correct port> and
-i option to accept remote connections.
Still I am getting error saying Connection can not be established. Any
quick pointers are highly appreciable.
Thanks,
Deep.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Problems with ODBC connections
2012-02-25 18:05 Problems with ODBC connections Sandeep Reddy <deep08u@gmail.com>
@ 2012-02-27 14:17 ` Adrian Klaver <adrian.klaver@gmail.com>
2012-03-02 19:41 ` Re: Problems with ODBC connections Sandeep Reddy <deep08u@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Adrian Klaver @ 2012-02-27 14:17 UTC (permalink / raw)
To: pgsql-sql; +Cc: Sandeep Reddy <deep08u@gmail.com>
On Saturday, February 25, 2012 10:05:07 am Sandeep Reddy wrote:
> Hi,
> I am completely new to postgres and I have some problems with ODBC
> connection.
> 1) I am running postgres server in Fedora Linux, and I am planning to
> connect server from windows client.
> 2) I have installed 64bit version of postgresql ODBC drivers
> 3) I am making sure that my postgres is running with -p <correct port> and
> -i option to accept remote connections.
>
> Still I am getting error saying Connection can not be established. Any
> quick pointers are highly appreciable.
The actual error message would be helpful:)?
A common reason for this is a firewall between the client and server that is
preventing connection to the server port.
Another reason is a pg_hba.conf that has not been configured to allow connections
from the client.
--
Adrian Klaver
adrian.klaver@gmail.com
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Problems with ODBC connections
2012-02-25 18:05 Problems with ODBC connections Sandeep Reddy <deep08u@gmail.com>
2012-02-27 14:17 ` Re: Problems with ODBC connections Adrian Klaver <adrian.klaver@gmail.com>
@ 2012-03-02 19:41 ` Sandeep Reddy <deep08u@gmail.com>
2012-03-04 08:56 ` Re: Problems with ODBC connections Jasen Betts <jasen@xnet.co.nz>
0 siblings, 1 reply; 4+ messages in thread
From: Sandeep Reddy @ 2012-03-02 19:41 UTC (permalink / raw)
To: Adrian Klaver <adrian.klaver@gmail.com>; +Cc: pgsql-sql
Hi, The Error message is like this
"Could not connect to server; A connection attempt failed because the
connected party did not properly respond after a periord......."
I have run postgres with option -i and changed the pg_hba.conf the IPv4
details to 0.0.0.0.0/0 to accept form all clients still facing the same
issues.
Any suggestions?
Thanks,
Sandeep.
On Mon, Feb 27, 2012 at 8:17 AM, Adrian Klaver <adrian.klaver@gmail.com>wrote:
> On Saturday, February 25, 2012 10:05:07 am Sandeep Reddy wrote:
> > Hi,
> > I am completely new to postgres and I have some problems with ODBC
> > connection.
> > 1) I am running postgres server in Fedora Linux, and I am planning to
> > connect server from windows client.
> > 2) I have installed 64bit version of postgresql ODBC drivers
> > 3) I am making sure that my postgres is running with -p <correct port>
> and
> > -i option to accept remote connections.
> >
> > Still I am getting error saying Connection can not be established. Any
> > quick pointers are highly appreciable.
>
>
> The actual error message would be helpful:)?
> A common reason for this is a firewall between the client and server that
> is
> preventing connection to the server port.
> Another reason is a pg_hba.conf that has not been configured to allow
> connections
> from the client.
>
>
> --
> Adrian Klaver
> adrian.klaver@gmail.com
>
--
sandeep
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Problems with ODBC connections
2012-02-25 18:05 Problems with ODBC connections Sandeep Reddy <deep08u@gmail.com>
2012-02-27 14:17 ` Re: Problems with ODBC connections Adrian Klaver <adrian.klaver@gmail.com>
2012-03-02 19:41 ` Re: Problems with ODBC connections Sandeep Reddy <deep08u@gmail.com>
@ 2012-03-04 08:56 ` Jasen Betts <jasen@xnet.co.nz>
0 siblings, 0 replies; 4+ messages in thread
From: Jasen Betts @ 2012-03-04 08:56 UTC (permalink / raw)
To: pgsql-sql
On 2012-03-02, Sandeep Reddy <deep08u@gmail.com> wrote:
> --e89a8ffba9b7723ad004ba47c368
> Content-Type: text/plain; charset=ISO-8859-1
>
> Hi, The Error message is like this
>
> "Could not connect to server; A connection attempt failed because the
> connected party did not properly respond after a periord......."
> I have run postgres with option -i and changed the pg_hba.conf the IPv4
> details to 0.0.0.0.0/0 to accept form all clients still facing the same
> issues.
> Any suggestions?
listen_addresses in postgresql.conf
--
⚂⚃ 100% natural
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2012-03-04 08:56 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-02-25 18:05 Problems with ODBC connections Sandeep Reddy <deep08u@gmail.com>
2012-02-27 14:17 ` Adrian Klaver <adrian.klaver@gmail.com>
2012-03-02 19:41 ` Sandeep Reddy <deep08u@gmail.com>
2012-03-04 08:56 ` Jasen Betts <jasen@xnet.co.nz>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox