Posts

Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached."

Image
Message from the system: "Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached." Always close your connection in the final block: or Increase pool size like in your connection string  string connectionString = "Data Source=localhost; Initial Catalog=Northwind;" + "Integrated Security=SSPI; Min Pool Size=10; Max Pool Size=100"; Don't use pooling string connectionString = "Data Source=localhost; Initial Catalog=Northwind;" + "Integrated Security=SSPI; Pooling=false;";
Post a Comment
Read more

Prevent IIS Session Timeout in ASP.NET

Image
There are scenarios that a user may want to keep a long session alive. For example, a help desk operator logs into a web application and takes phone calls and in between submits changes to the backend systems. The phone call may last over an hour and the operator may stay in one web page and need that session to be valid when she submits the changes. In ASP.NET, there are several common simple solutions for that. One of them is to set the session timeout attribute (minutes) in web.config. 1 <sessionState mode ="InProc" timeout="xxx"/> Some people are confused at the timeout setting in web.config and another in IIS and ask which overwrites which. However, this is not complete for ASP .NET 2.0+. Open IIS->Application Pools->Select the Application pool for your application->Advanced Settings, set the idle timeout for xxx minutes". Otherwise, the worker process is still stopped after 20 minutes(default) and your session state wi...
Post a Comment
Read more

Patch Jqgrid for Asp.net dll

Image
Some Background : https://docs.microsoft.com/en-us/dotnet/framework/tools/ildasm-exe-il-disassembler "The IL Disassembler is a companion tool to the IL Assembler (Ilasm.exe). Ildasm.exe takes a portable executable (PE) file that contains intermediate language (IL) code and creates a text file suitable as input to Ilasm.exe. This tool is automatically installed with Visual Studio. To run the tool, use the Developer Command Prompt (or the Visual Studio Command Prompt in Windows 7). For more information, see Command Prompts ." Step 1 : On Dos prompt:  ILdasm /all /out:trirand.IL Trirand.Web.dll Step 2  : trirand.IL is a text file that can be edited using a text editor. We can make the changes in the file to avoid the limitation of number of days past the compilation time.  To do that we search for the string : "This is a trial version of jqSuite for ASP.NET which has expired." or a part of it. Then change the number of days afte...
Post a Comment
Read more

Crystal Reports Error 1606 could not access network location v4.030319\ASP.NETClientFiles\

Image
Information After trying to install Crystal Reports runtime engine for .Net Framework, the process fails with that message. Solution open a new  command prompt with elevated privileges. After navigating to  CRRuntime_64bit_13_0.msi file, proceed to install. Please Donwload Crystal Reports runtime engine for .net  Framework from : https://wiki.scn.sap.com/wiki/display/BOBJ/Crystal+Reports%2C+Developer+for+Visual+Studio+Downloads
1 comment
Read more

How to Implement jquery UI on Google Blogger

Jquery UI  is a powerful java library and can be used in Blogger by adding th following code just after the tag <head> in the templates option  ( Design -> Html Edition  ) <link href='http://ajax.googleapis.com/ajax/libs/jqueryui/1.8/themes/base/jquery-ui.css' rel='stylesheet' type='text/css'/>   <script src='http://ajax.googleapis.com/ajax/libs/jquery/1.5/jquery.min.js' type='text/javascript'/>   <script src='http://ajax.googleapis.com/ajax/libs/jqueryui/1.8/jquery-ui.min.js' type='text/javascript'/> For example , if you want to use the accordion UI widget you can additionally put this code : <script type='text/javascript'>     $(function() {         $(&quot;#accordion&quot;).accordion({             collapsible: true,active:false         });     }); </script> Then on an...
Post a Comment
Read more

Asp.net Security : A case using WebInspect

Image
Recently a client contacted me and showed me an application developed in asp.net and Sql server. They explained me that the temporary site they implemented on a hosting service was tested for vulnerabilities using webinspect , ( a web security scanner  from Hp ) and the results were alarming.  The final user, a  well known local bank , outsourced the vulnerabilities detection service from a Canadian company which in turn submitted a report  from the tool after a 4-day scan. Web security is a concern, specially for a bank. In an interesting study ,WhiteHat Security  Inc, a US company based on Santa Clara CA, found that "the average website had nearly 13 serious vulnerabilities"  and  "Banking, Insurance, and Healthcare industries performed the best overall regarding the average number of serious vulnerabilities having 5, 6, and 8 respectively. The worst were the IT, Retail, and Education sectors with an average of 24, 17, and ...
Post a Comment
Read more