Yearly Archives: 2007

26 posts

SHUTDOWN is in progress. Login failed for user ‘…’. Only administrators may connect at this time.

Today, one of my web sites went down and the application sent me an exception error message like “SHUTDOWN is in progress. Login failed for user ‘…’. Only administrators may connect at this time.” It worried me at first because I thought my web site was under some malicious attack caused the server to shut down. So I searched the Internet with the error message and it turned out that it had nothing to do […]

ConstraintException occurred when updating DataTable with TableAdapter

I have been using SqlDataAdapter and strong typed DataSet and DataTable in my projects in .NET 1.1 for quite some time and have not had any problems. Now, in .NET 2.0, SqlDataAdapter is replaced with TableAdapter, which is much easier than SqlDataAdapter to create a data access layer. When I played with it in one of my projects last week, I came across an exception error when updating a DataTable with TableAdapter. The error happens […]

System.ArgumentOutOfRangeException occurs when updating DataView object

I have been working on a project which involves sending out emails to our customers in the past week and came across a very interesting error with a DataView object. The application is required to send out batch emails once a day, so I created an email message queue table to store the outgoing email messages. After a message is sent, the column that stores the delivery status will be changed from 0 to1 so […]

Keyboard Shortcut Reference Posters for Visual Studio

When I was searching the Internet for some keyboard shortcuts for Visual Studio 2005, I found that Microsoft already kindly created some FREE keyboard shortcut reference posters for VB, C#, and C++.  Here are the links: Visual Basic 2005 Keyboard Shortcut Reference Poster Visual C# 2005 Keyboard Shortcut Reference Poster Visual C++ 2005 Keyboard Shortcut Reference Poster These posters, however, only list the commonly used keyboard shortcuts for Visual Studio, and a complete list of […]

Fedora Core 8 released

Although I am a developer on Windows platform, mainly with .NET framework, I still try to keep up with what is happening in Linux community. Among all the major Linux distributions, Fedora Core is my favorite, and Ubuntu comes next. One of the reasons that I like Fedora Core is there are many developers supporting it by building many useful applications for this distribution. Another feature of FC that attracts me is that it makes […]

From Bugzilla to OnTime

We have been using Bugzilla as our bug tracking system for quite a long time, but recently my department decided to switch to OnTime by Axosoft because it meets our needs better, for example, OnTime has the ability to separate defects from features and incidents, and to generate professional-looking reports, etc. After the decision was made, I was assigned to make the switch as smooth as possible. The biggest challenge I had was to find […]

HashTable, ListDictionary, and HybridDictionary

HashTable is ideal for creating lookup tables because it can very quickly find the value of an item from a large collection of items based on the item’s key. However, it may become an overkill if the collection is relatively small, say about 10 items or less, because of the overhead of HashTable. In this case, ListDictionary is a better choice than HashTable. ListDictionary is a simple implementation of IDictionary with a singly linked list. […]

The remote server returned an error: (503) Server Unavailable

One of our applications started giving an error this morning like this: The remote server returned an error: (503) Server Unavailable. The stack trace shows that the application was trying to parse a template in XML format and encountered an error on the DTD file. When the line of DOCTYPE was commented out, the error went away and the application came back running. Here is the DOCTYPE of the application: <!DOCTYPE html PUBLIC “-//W3C//DTD XHTML […]

WordPress 2.3 is out

Just before going to bed, I turned on my computer to check my emails and to check my blog stats, which is my daily routine before the day is out. I noticed that WordPress 2.3 is released. This version is named “Dexter” for the great tenor saxophonist Dexter Gordon. I am very excited about this new version, and cannot wait to upgrade my current version. Unfortunately, it’s about mid-night now, and I should be in […]

Error message: Object reference not set to an instance of an object

If you use the TableAdapter Configuration Wizard in Visual Studio 2005 to create a strong-typed dataset (as described in Scott Mitchell’s ASP.NET 2.0 Data Access Tutorial – Creating a Data Access Layer), you will be asked if you would like to save the database connection string in the configuration file. If you choose to save it, it will be placed in the <connectionStrings> section. But what if you want to change the name of the […]