[Progress Communities] [Progress OpenEdge ABL] Forum Post: Connection Pooling Confusion for ODBC/SQL92 Clients (CPTimeout)

  • Thread starter Thread starter dbeavon
  • Start date Start date
Status
Not open for further replies.
D

dbeavon

Guest
Is there any supported way of manipulating the connection pool timeout from an ODBC client? I thought there was a connection string option (CPTimeout). But it doesn't seem to be having any effect for some reason. For example, I'm trying to set my connection pooling in the connection string with CPTimeout like so: DRIVER=Progress OpenEdge 11.7 Driver;DB=mydata;PORT=5005;HOST=myhost;DefaultIsolationLevel=READ UNCOMMITTED; CPTimeout=5 ...But as I said, that seems to have no effect. I haven't found any explicit documentation that says this is a valid argument in a connection string. But I found a reference to "CPTimeout" here: Progress KB - Poor performance with ODBC when CPTimeout is set to zero I am able to configure the timeout for the entire client machine using ODBC admin like so : (image) This is working as I expect and it impacts all odbc connections using that driver. But I would much rather do it in a connection string since it is easier to deploy and configure. Any help would be greatly appreciated. Thanks, David

Continue reading...
 
Status
Not open for further replies.
Back
Top