Connection Failure

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
glose
Posts: 5
Joined: Mon 24 Aug 2009 15:33

Connection Failure

Post by glose » Sun 27 Sep 2009 16:05

I'm seeing the intermittent error at numerous user sites -

PgSqlException ErrorCode=-2147467259
Message=CONNECTION FAILURE
Severity=1 (0x1)
Position=0 (0x0)
LineNumber=0 (0x0)
ErrorCode=-2147467259 (0x80004005)

Devart.Data.PostgreSql.PgSqlConnection.d()
at Devart.Data.PostgreSql.PgSqlConnection.Open()


Can you shed some light on the possible causes and meaning of this error as well as the recommended way of recovering from it.

Tx

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Mon 28 Sep 2009 15:43

Please give us the following information:
1) the version (2 or 3) of the protocol you use in your connection string. We recommend you to use protocol 3;
2) are you using asynchronous execution of methods in your code?
3) the version and edition of your dotConnect for PostgreSQL. You can see it in the Tools | PostgreSQL | About menu of Visual Studio. Does the problem persist with the latest 4.55.44 version of dotConnect for PostgreSQL?
4) please send us ( http://www.devart.com/company/contact.html ) a small test project where the problem occurs. We will try to reproduce the issue.

We sometimes encountered such problem with protocol 2 in our autotests. If you use protocol 3, this is rather a network problem.

Post Reply