To control oracle connection through DataSource: possible?

[dcoracle600pro]

Hi,

We would like to disconnect from Oracle at some point in ASP.NET code.
Having OracleDataSource initiated a session:

Devart.Data.Oracle.Web.OracleDataSource SourceTableRowData = new Devart.Data.Oracle.Web.OracleDataSource();
SourceTableRowData.ConnectionString = "User Id=" + UserName + ";Password=" + Password + ";Server=" + ServerName + ";";
SourceTableRowData.SelectCommand = "select ....";
DataView dv = (DataView)SourceTableRowData.Select(new DataSourceSelectArguments());
....

how do we terminate session? Because the session remains open for indefinite time.
This does not work:

SourceTableRowData.Dispose();

[Pinturiccio]

Add the following record to your connection string:

Code: Select all

pooling=false;

When you turn off the pooling, a connection will be opened for performing a command and closed after the command execution is over.

[dcoracle600pro]

Thank you, it works!