[Stackoverflow] [Progress OpenEdge ABL] OpenEdge ODBC connection timeout

SuperVillainPresident

Guest

Aug 11, 2020

My issue is that I need to set the connection timeout to longer than the default. It ignores the fact that I set the timeout to longer.

This part creates the odbcConnection object:

Code:

var odbcConnection = new OdbcConnection(district.DBConnectionString);
odbcConnection.ConnectionTimeout = 60;
                        
return odbcConnection;

Which is then returned to here:

Code:

using(IDbConnection db = SisFlavorDBFactory.GetDownloadConnection(District, Context))

I implemented this a year ago and at that time it did extend the connection timeout. But it is no longer doing that. I'm not aware of anything changing.

The connection string is: DRIVER={Progress OpenEdge 11.1 Driver};UID=;PWD=;HOST=;PORT=;DB=;

I tried adding the connect timeout attribute to it but it seems that doesn't work with OpenEdge. I'm open to any suggestions.

Continue reading...