Postgres Pro
Downloads
Home   >   mailing lists

Re: Communication error while getting a tuple - Mailing list pgsql-odbc

From PG User
Subject Re: Communication error while getting a tuple
Date
Msg-id CAB7tN8ZTquvxd4eTv8FjtSRf1WrxZQWPv96zVR2YRD2kzT7_+Q@mail.gmail.com
Whole thread Raw
In response to Re: Communication error while getting a tuple  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-odbc
Tree view
Thank you for reply.

I tried many options and found that when I change from sslmode=prefer to sslmode=allow, I did not get any error.

Do you know the reason for the same?

Thanking you.

- Nachiket


On Tue, Apr 1, 2014 at 9:38 PM, Michael Paquier <michael.paquier@gmail.com> wrote:
On Wed, Apr 2, 2014 at 1:13 PM, PG User <pguser1982@gmail.com> wrote:
> SQLState: 08S01(SQLSTATE_COMMUNICATION_LINK_FAILURE)
> What can be possible reason for the same?
Probably network problem, even hardware failure:
http://social.msdn.microsoft.com/Forums/sqlserver/en-US/40eededa-752a-4445-8fa4-a023df69031f/sqlstate08501-or-communication-link-failure?forum=sqldataaccess

You might even get that on a server facing a high load.
--
Michael

pgsql-odbc by date:

Previous
From: Heikki Linnakangas
Date:
Subject: UseDeclareFetch bugs, found & fixed
Next
From: Daniel Díaz
Date:
Subject: SSL slow when using libpq.dll