PostgreSQL 8.1.4 - Error 08006

Guest · Post by **Guest** » Fri 02 Jun 2006 17:39

I am using the Postgres Dataadapter Version 2.5 with Postgres 8.1.4. When I select a large amount of Data I get Error Code 08006 (Connection fault or Host does not respond).

Here is my connect string:
SERVER=xxx; DATABASE=xxx; USER=xxx; PASSWORD=xxx; pooling=false; protocol=2; Connect Timeout=30;

The error does not show up every time. When I select a small amount of data there is usually no problem but when I select a large table I often get the error message.

I cant imagine network problems being a reason for this.

Can anybody help?

Alexey · Post by **Alexey** » Mon 05 Jun 2006 08:16

We have never been reported such error. Try to set

Code: Select all

protocol=3;

in the ConnectionString.

Guest · Post by **Guest** » Tue 06 Jun 2006 12:52

Your recommendation does not help. I still have the problem. Even worse:
When I set "protocol=3" all timestamps are set to 01-01-2000. Crazy!

Alexey · Post by **Alexey** » Wed 07 Jun 2006 06:20

Please send us small test project if possible to reproduce the problem; iclude definition of your own database objects and backup of database data. Do not use third party components. Also describe upon which statements the error occurs.