Page 1 of 1

Connection Failure

Posted: Sun 27 Sep 2009 16:05
by glose
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

Posted: Mon 28 Sep 2009 15:43
by Shalex
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.