Connection Timeout and Connection Lifetime are ignored

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
CNPSV
Posts: 27
Joined: Thu 01 Nov 2007 09:48

Connection Timeout and Connection Lifetime are ignored

Post by CNPSV » Thu 25 Jun 2009 09:29

//CODE:
PgSqlConnection conn = new PgSqlConnection();

string argConn = "Server=192.168.2.10;Port=5432;User Id=aaa;Password=aaa;Database=bbb;";

//I don't have access to the IP address

string connString = argConn;
connString += "Connection Timeout='2';";
conn = new PgSqlConnection(connString);
//conn.ConnectionTimeout is 2
try
{
conn.Open();
}
catch (Exception ex)
{
}
//CODE.

When I try to open the connection, it should really wait for only 2 seconds, but it stays for about 15 seconds.
How can I resolve this problem, because I want to check quickly if I have or I don't have a connection to the server.

//System
XP SP3 or Windows 7
VS 2005, VS 2008 - C#
dotConnect 4.50.29.0

Have a nice day.

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

Post by Shalex » Fri 26 Jun 2009 14:11

Thank you for the bug report. This is a known problem. I will post here when it is fixed.

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

Post by Shalex » Mon 06 Jul 2009 12:11

The issue is resolved. Look forward to the next build of dotConnect for PostgreSQL. I will post here when it is available.

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

Post by Shalex » Wed 15 Jul 2009 10:34

The new build of dotConnect for PostgreSQL 4.55.37 is available for download now.
It can be downloaded from http://www.devart.com/dotconnect/postgr ... nload.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to http://www.devart.com/forums/viewtopic.php?t=15320 .

Post Reply