Page 1 of 1

PostgreSQL 8.1.4 - Error 08006

Posted: Fri 02 Jun 2006 17:39
by Guest
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?

Posted: Mon 05 Jun 2006 08:16
by Alexey
We have never been reported such error. Try to set

Code: Select all

protocol=3;
in the ConnectionString.

Posted: Tue 06 Jun 2006 12:52
by Guest
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!

Posted: Wed 07 Jun 2006 06:20
by Alexey
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.