Bambang F. Indarto

The Journey… The Shares

Archive for the ‘Development’ Category

SQL Server Pending Installation Error

Posted by bfindarto on December 1, 2008

Some of my students were trying to install SQL Server 2000 on a Windows 2000 and windows XP OS machine lately but they got this error message:

“A previous program installation created pending file operations on the installation machine. You must restart the computer before running setup.”

Well… In this case that an erroneous pending file copy operation in the registry is causing the SQL Server installation to believe another installation is underway, which is preventing users from continuing the installation. To resolve this error, we may perform the following steps:

  1. Restart the computer and see if you are able to run the setup. If the restart does not help, use the next solution.
    1. Click Start, and then click Run.
    2. Type: “Regedit” (without the quotation marks) in the Open dialog box
    3. Click OK.

      NOTE: BackUp the registry by clicking on the File menu, and then click Export. (Or Export Registry File from the Registry menu in Windows 2000).

    4. In Registry Editor, expand the following registry subkey:HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager
    5. In the right-pane of the Registry Editor window, right-click PendingFileRenameOperations. On the shortcut menu that appears, click Delete.
    6. In the Confirm Value Delete message dialog box that appears, click Yes.
    7. On the File menu, click Exit.

      NOTE: In Windows 2000, click Exit on the Registry menu.

    8. Restart the computer.
    9. Using the Registry Editor, verify that the PendingFileRenameOperations registry value is not available.
    10. Check other control set keys (for example, ControlSet001, ControlSet002, and so forth) for the same values and also delete them.

Run the SQL Server installation again.



Posted in Development | Tagged: , , | Leave a Comment »

Start to Post In Development

Posted by bfindarto on August 13, 2008

One of my purpose when I start this blog is that I want to use it for self learning. As I do also training in development, I’ll start to write about development.

And I think, it is better to me to start on things that my student asked me. Well, one of the best way to learn is just by try to find solution.  🙂

I remember a few weeks ago, there was a question about how to get month name, or day name from a specific date-time value. Well, one way is, we can create a list (or an array) of month or day names and then relate the names to the the specific date-time value using condition statements (if..else or Which is not too efficient.   🙂

The other way is by using CultureInfo classs from System.Globalization namespace. The CultureInfo class holds culture-specific information, such as the associated language, sublanguage, country/region, calendar, and cultural conventions. This class also provides access to culture-specific instances of DateTimeFormatInfo, NumberFormatInfo, CompareInfo, and TextInfo. These objects contain the information required for culture-specific operations, such as casing, formatting dates and numbers, and comparing strings (MSDN).

Lets try one example.

In this example, I just want to get the name of a specific date (2008/8/12).


So, when I press the button, the month name should appear in the text box.

Dim b As Integer = New Date(2008, 8, 12).Day()
Dim GetNames As New System.Globalization.CultureInfo(“en-US”)
TextBox1.Text = GetNames.DateTimeFormat.GetMonthName(b)

One benefit of using this class is, we can produce names in many language. If I use “en-US” as the culture name, the month name would be in American English. If I use “id-ID“, the month name would be in Indonesian.

en id

You may find the reference in the MSDN about Globalization.CultureInfo class.

Posted in Development | Leave a Comment »