How can I use "Validate Connection = true" as a connection string property in the web.config file? My connection string is like

<add name="ConnectionString" connectionString="Data Source=X.X.X.X/orcl;User Id=XXX;Password=XXX"/> 

It works but sometimes server returns a non-active connection from the pool when I try to open a connection. I don't always want to check if the connection is alive. I have found Validate Connection property from Oracle documentations. I need to add "Validate Connection" property setted to true. So I try

<add name="ConnectionString" connectionString="Data Source=X.X.X.X/orcl;User Id=XXX;Password=XXX;Validate Connection = true"/> 

but I get System.ArgumentException: 'Validate Connection' is an invalid connection string attribute.

How can I use this property properly? Couldn't find any working example.

Related posts

Recent Viewed