I have a file upload Web application running perfectly fine on IIS 6 server, but when I migrated it to an IIS 7 server, when I try to upload a large file, it throws an error saying: The request filtering module is configured to deny a request that exceeds the request content length. It puzzled me because I have this setting in my Web.config file: <httpRuntime maxRequestLength=”2097151″ executionTimeout=”7200″ /> This setting should allow me to […]
Tips & Tricks
146 posts
Take a look at the following MS SQL query: SELECT MT.MeetingTypeName, COUNT(DISTINCT(A.MemberId)) AS AttendanceTotal FROM MeetingAttendance AS MA INNER JOIN MeetingType AS MT ON MA.MeetingTypeId = MT.MeetingTypeId WHERE (MA.MeetingDate = @meetingDate) AND (MT.MeetingTypeId IN (1,2,3)) What if the IN clause in the above query needs to be dynamic? Can you use a parameter for the IN clause like this? SELECT MT.MeetingTypeName, COUNT(DISTINCT(A.MemberId)) AS AttendanceTotal FROM MeetingAttendance AS MA INNER JOIN MeetingType AS MT ON MA.MeetingTypeId […]
Do you have this experience that your application has been running fine on one computer, but suddenly gives you an error as follows when you publish it to another computer? Calling LoadLibraryEx on ISAPI filter “C:\Windows\Microsoft.NET\Framework\v4.0.21006\aspnet_filter.dll” failed This error is very common on x64 OS computer with IIS 7 installed. The reason is that the default application pool (or the application pool your application uses) on IIS 7 does not support 32-bit application. The fix […]
An article of mine is published on Experts-Exchange web site. How to Create a 20 Page Microsoft Word Test Document in 5 Seconds Hope you find it helpful.
If you have Visual Studio 2008 installed on a 64-bit OS and are planning to upgrade your Microsoft Office to the latest Office 2010, then be cautious: the upgrade will cause your Visual Studio 2008 web designer to hang and you will have to manually kill devenv.exe process from Task Manager. The root cause of the problem is that Office 2007 and Visual Studio 2008 share a 32-bit component: MSXML5. The upgrade process (manual uninstall […]
I bet every Outlook user knows how to create rules in Outlook to help organize email, and Outlook 2010 extended this feature by adding a new feature called “Quick Steps” to help user organize email even better and faster. The Quick Steps feature allows user to predefine a series of actions that user would like to performs on an email. For example, if you receive a request from a customer and the request requires your […]
If you installed Microsoft Office 2010 Beta as I did, you will find that it does not integrate well with Communicator 2007 R2 and the Live Meeting Add-in does not work either. To fix those problems, you need the following two updates: 1. Office 2010 Beta Integration with Communicator R2 & the Live Meeting Add-In 2. January 2010 Updates for Communicator 2007 R2 and OCS 2007 R2 Once you have the above two updates installed, […]
I don’t understand why it is so hard to delete a printer in Vista. Start->Control Panel->Hardware and Sound->Printers, then right-click the printer that needs to be deleted, and choose “Delete”. Nothing happens except the printers shows “Deleting”, no error message, printer icon still there. I thought maybe I need to run as administrator, so I right-clicked the printer icon, and choose “Run as administrator”->”Delete”, still no luck. Finally, I had to do these to get […]
I installed the latest version of Process Explorer (v12) on my Vista 64-bit computer and set it to replace the default Task Manager, however, when I right-clicked the task bar to launch Task Manager, Process Explorer did not come up but an error message saying cannot find taskmgr.exe file: Windows cannot find ‘C:\Windows\system32\taskmgr.exe’. Make sure you typed the name correctly, and then try again. The old version of Process Explorer does not have this problem. […]
If you use XML string as parameter to update your SQL database table as I discussed in my last post, if the server is SQL Server 2000 and the XML string contains a datetime string, you will get a SQL error as this: Syntax error converting datetime from character string Cause: When generating XML string from DataTable object, all DateTime values are converted into strings in ISO 8601 format. However, ISO 8601 format is support […]