Archive for October, 2008

Microsoft reporting: Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.

This error was bugging me for a long time until I found this excellent forum discussion:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=541116&SiteId=1
The following points summarize the causes and solutions from the forum and offer some additional help:
1. Check if you have changed the length of any fields in the underlying database table after creating the dataset. If you have, [...]

A better way of handling maxRequestLength exceptions

ASP.NET 2 includes the FileUpload control to make it easier to create pages that allow users to upload files. The default maximum file size is 4096 KB to minimize the potential for denial of service attacks. You can change the maximum file size by editing your configuration files (see for example http://msdn2.microsoft.com/en-US/library/system.web.configuration.httpruntimesection.maxrequestlength(VS.80).aspx and http://support.softartisans.com/kbview_825.aspx).
The problem [...]

Creating multiple websites in IIS 6 for student projects

Every term I had to create between 100 and 200 web sites for students in my classes. Here are the steps I used to create those site in IIS 6. The student’s active directory accounts were already set up by our system administrator. I use FrontPage Server Extensions to allow students to transfer files to [...]