By default IIS 7 does not allow ISAPI and CGI through .Net 1.1. So if you are working with older code on IIS 7 you will need to follow these steps to resolve the issue: 1. Open IIS and click the server name 2. Double click “ISAPI and CGI Restrictions” 3. Right click ASP.NET v1.1 […]
Archive for the 'Error' Category
Arithmetic overflow error converting expression to data type datetime
Condition: <asp:SqlDataSource ID=”PolExpCurrentMo” runat=”server” ConnectionString=”< %$ ConnectionStrings:appConnectionString2 %>” SelectCommand=”SELECT * FROM [VendorList] WHERE _([EXPIRATION_DATE] >= @EXP_BEGIN) AND ([EXPIRATION_DATE] < @EXP_END) AND _([EXPIRATION_CONTACT] = @EXPIRATION_CONTACT) ORDER BY EXPIRATION_DATE "> <selectparameters> <asp:parameter DefaultValue=”YES” Name=”EXPIRATION_CONTACT” Type=”String” /> <asp:parameter Name=”EXP_BEGIN” Type=”String”/> <asp:parameter Name=”EXP_END” Type=”String” /> </selectparameters> Code behind default value ‘ *current months date parameter PolExpCurrentMo.SelectParameters(“EXP_BEGIN”).DefaultValue = _DateTime.Now.Month.ToString() + […]