PostgreSQL 8.1.4 - Error 08006

PostgreSQL 8.1.4 - Error 08006

Postby 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?
Guest
 

Postby 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.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby 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!
Guest
 

Postby 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.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect for PostgreSQL