Setting optional ADO connection parameters

aolson · December 28, 2018, 4:01pm

I am using RelativityServer (latest beta) to connect to my Pervasive.SQL database server via ADO.NET. All is working well, but I’ve run into a query that takes awhile to finish, and i’m getting exceptions when the default timeout expires. There is a parameter on the PSQL command object that I need to set called CommandTimeout and I wish to set it to zero. Can this be done in the DataAbstract.daConfig file?

antonk · December 28, 2018, 4:11pm

Hello

AFAIK Pervasive.SQL doesn’t allow to set timeouts via connection string, so .daConfig won’t be of any help here.
I’ll log an issue to expose default connection timeout to the Relativity AdminTool (ETA is somewhere during next week). Will that work for you?

Regards

RemObjectsSoftware · December 28, 2018, 4:11pm

Thanks, logged as bugs://81635

aolson · December 28, 2018, 4:47pm

The sooner the better, but at least I figured out what was causing this…

aolson · December 31, 2018, 11:06pm

Any chance this could be ready Wednesday?

antonk · January 2, 2019, 9:51am

Please drop a mail to support@

RemObjectsSoftware · January 4, 2019, 1:08pm

bugs://81635 got closed with status fixed.