Hi,
We are using Open Access Classic and having problem that Long running Store procedure throwing Request timeout messages....In app.config we already set conTimeout = 720 but still after 2 mins it thru Request Timeout Message....
We are using it in our aps.net projects... and have following setting in app.config
<backendconfigurations>
<backendconfiguration id="mssqlConfiguration" backend="mssql">
<mappingname>mssqlMapping</mappingname>
<logging.logEvents>none</logging.logEvents>
<conTimeout>720</conTimeout>
<maxActive>100</maxActive>
<maxIdle>100</maxIdle>
<lockTimeout>20000</lockTimeout>
</backendconfiguration>
And while setting Object scope we have following Code:
string myconfig =
"<openaccess>" +
"<references>" +
"<reference assemblyname='" + AssemblyName.Trim() + "' />" +
"</references>" +
"<connections>" +
"<connection id='" + ConnectionID + "'>" +
"<databasename>" + Database + "</databasename>" +
"<servername>" + server + "</servername>" +
"<integratedSecurity>false</integratedSecurity>" +
"<user>" + UserID + "</user>" +
"<password>" + password + "</password>" +
"<backendconfigurationname>mssqlConfiguration</backendconfigurationname>" +
"</connection>" +
"</connections>" +
"</openaccess>";
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.LoadXml(myconfig);
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.LoadXml(myconfig);
return Telerik.OpenAccess.Database.Get(ConnectionID, xmlDoc.DocumentElement).GetObjectScope();
Can you pls advise what is missing in this code.
Thanks
devoas.