Thread: Problems with ODBC connections

Problems with ODBC connections

From
Sandeep Reddy
Date:
Hi,<br />I am completely new to postgres and I have some problems with ODBC connection. <br />1) I am running postgres
serverin Fedora Linux, and I am planning to connect server from windows client. <br />2) I have installed 64bit version
ofpostgresql ODBC drivers<br /> 3) I am making sure that my postgres is running with -p <correct port> and -i
optionto accept remote connections.<br /><br />Still I am getting error saying Connection can not be established. Any
quickpointers are highly appreciable. <br clear="all" /><br />Thanks,<br />Deep.<br /> 

Re: Problems with ODBC connections

From
Adrian Klaver
Date:
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


Re: Problems with ODBC connections

From
Sandeep Reddy
Date:

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

Re: Problems with ODBC connections

From
Jasen Betts
Date:
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