Norse Technologies Knowledge Base Free Knowledge Articles

Sometimes in testing network settings and authentication ( for instance when setting up a Samba server and users on a CentOS, Ubuntu, or Feroda Linux system) I often find it useful to force my Windows PC client to “forget” the login username and password that it has on record, for the current session, so that I may login again with another username/password combo. Easily accomplished, this Windows trick works on all modern Microsoft operating systems.

The situation: You need to login again to a network share on a Windows file server, or a Linux server,  without rebooting the client computer.

The fix: Disconnect from the shares using the NET command.

1. Open a command prompt. (My favorite way is: Win-R, type cmd, press Enter)
2. Type NET USE * /DELETE
3. It will prompt you for verification, type Y and Enter.

That’s it! Enjoy, and may your login be forgotten!

Courtesy, Microsoft: http://support.microsoft.com/kb/308582

Posted under Microsoft, Network, Software, Windows

The most awesome emulator of all time, puTTY.exe, just got even easier to use. Along with loggiong automatically into a SSH session add the Windows shortcut that loads a saved session and launches it, now you have one click shell access to your Linux host from your Windows PC.

Here’s how:

1. Download puTTY.exe
2. Save it to the folder  C:\puTTY\
3. Open a Windows Explorer window in C:\puTTY\
4. Run puTTY.exe once, and create a “saved session”, making note of what you name it. My example below uses the name my neatly named Saved Session
5. Right-click-drag puTTY.exe and drop it next to itself, this creates a shortcut to the .exe file.
6. Right-click the shortcut you just created, on the popup menu click Properties.
7. In the Target box, add -load “your-saved-session-name” after C:\putty\putty.exe
8. The final content in the target box should look like:

   C:\putty\putty.exe -load "my neatly named Saved Session"

9. Save the shortcut. Viola! Move or copy this shortcut anywhere you like (e.g. your Desktop, your QuickLaunch toolbar, your custom explorer toolbar, etc.) and you have 1-click access to a command prompt on your Linux / Unix host.

Enjoy!

Posted under Apple, Freeware, Linux, Microsoft, Network, Software, WebDev, ZyXel

So, you have a Windows system that gets a BSOD (Blue Screen Of Death) during bootup, and you can’t see what it says before it disappears. Not a big deal, except that the system won’t boot into safe mode either, so you can’t do the regular method, using the Windows GUI, to set the system properties settings so that the system does not automatically reboot when the blue screen appears. Yikes! Well, if you want to stop the system from rebooting beforee you can get the STOP: codes, and find out how to fix the problem, here is a really neat way:

How To Disable Automatic Restart For BSOD If You Are Unable To Get Into Windows

Download UBCD  here

Another neat tip from a Japanese Lenovo support board, save me some work today (use Google to translate):

Need to Repair Install Windows (second R during setup) when STOP: 0 × 0000007B (0 × F789EA94, 0) / INACESSIBLE_BOOT_DEVICE occurs on restore of OS onto new hardware / storage controller.

Thanks all for the help!

Posted under Hardware, Microsoft, Operating System, Software

The following is totally copied from myfixes.com excellent article.

This article applies to the following type of errors:

Resolution:

A. Boot the system into the Recovery Console and CHKDSK

B. Perform the System Restore
Inside the Recovery Console type the following commands to change the directory to the system restore directory:

If you get an Access Denied error:click here
If you don’t get an Access Denied error :

If there is no _resto~1 folder or if there are no restore points inside it:click here

If the _resto~1 folder exists, inside it there are several folders named RP1, RP2. These are restore points. RP1 is the oldest restore point. You can use

to view what RP folders are available. If no restore points are available click here. Otherwise choose the most convenient RP folder. Supposing we have RP3 available let’s type in:

Change the directory to snapshot:

Restore the main registry branches. If you are being asked if you want to overwrite type in y to agree.

Type exit to reboot the system. Start the computer normally

Based on:
The support.microsoft.com article:
http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q307545&ID=KB;EN-US;Q307545

The icompute.info article:
http://www.icompute.info/System_restore_from_xp_cd.htm

Posted under Microsoft

In a Microsoft Excel spreadsheet cell one can use a custom function to effectively grab all test after the final (last) occurrence of a particular character or string. This is accomplished by simply creating a Custom Function and then using that function in a cell formula. Following is the code and instructions for how to create and then implement the function.


Function PullAfterLast(rCell As Range, strLast As String)
PullAfterLast = Mid(rCell, InStrRev(rCell, strLast) + 1, 256)
End Function


1. Highlight the above code, and copy it to the clipboard by pressing CTRL-C, or by right-clicking on the text and on the resulting popup window left-clicking on Copy.
2. Open Microsoft Excel (or proceed to step 2 if you prefer to open Excel by clicking  the desired existing .xls file directly.).
3. Open the workbook you wish to use the function with, or create a new workbook.
4. Open the Visual Basic Editor window by pressing ALT-F11 on the keyboard, or clicking Tools > Macros > Visual Basic Editor
5. Insert a new module by right-clicking on ThisWorkbook > Insert > Module or on the toolbar clicking Insert > Module
6. Paste the clipboard contents (which is the code above this numbered procedure) into the code window by pressing CTRL-V, or by right-clicking in the code window and on the popup menu clicking on Paste, or by clicking the menu toolbar on Edit and clicking on Paste.
7. Close the Visual Basic Editor by presing CTRL-Q, or by clicking File on the menu toolbar and then clicking Close and Return to Microsoft Excel.

The custom user defined function is now available to be used in the formulas of cells. To use it, the following syntax format is used in the cell’s formula:

=PullAfterLast(A1,"yourstring")

Of course, replace yourstring with the appropriate character or string.

This info was combined from ozgrid.com article about how to make custom functions easily, and vertex42.com article where Dave Hawley gave the universe this function’s code, many thanks!

Posted under Excel, Microsoft, Office

The pesky carraige return and new line characters, while providing a way to present text for human viewing, are not always desirable when working in a spreadsheet program like Microsoft Excel or OpenOffice.org.

In Excel, a bit of code provided by Ivan Moala on mrexcel.com, works wonders. Here is the code:


'Created by Chip Pearson
'Cleans up data by removing tabs and carriage returns in worksheet cells.
Sub CleanUp()
Dim TheCell As Range
For Each TheCell In ActiveSheet.UsedRange
With TheCell
If .HasFormula = False Then
.Value = Application.WorksheetFunction.Clean(.Value)
End If
End With
Next TheCell
End Sub


Here’s how to use it:

• In Excel click Tools > Macro > Visual Basic Editor (or just hit Alt-F11)
• In the top-left pane under the Project heading, double-click the name of the sheet you want to strip all the newlines and carriage returns from.
• In the window that pops up, paste the code above into the empty box under where you see General and Declarations.
• Run the macro by clicking the “play” button above, or hit F5

Warning: make a backup copy of your Excel workbook before performing the above procedure.

Posted under Excel, Microsoft, Uncategorized

Using conditional formatting one may easily show duplicate values in any chosen range of data. Find all duplicate values, and highlight any values that appear more than once.

=COUNTIF(A:A,A2)>1

This is the meat, and here is how:

• Highlight the cell to work on.
• Click Format > Conditional Formatting
• Set Formula Is
• Enter the formula above, replacing the ranges as follows:
  • (A:A means that it will look inside the entire A range. Replace this with your own range, e.g. B3:B5 or CC:CC
  • ,A2) means to count how many times the value in A2 appears in the designated range. This needs to match the cell you are currently working on.
• Then set the format you want to see when the count of identical values existing in the range is greater than one. This value can be altered to a higher number in order to highlight cells that have more than two duplicates, e.g. change it to be >5 to highlight the cell when at least 5 cells have the same value as the current cell, including this cell itself.
• Copy the formula only to other cells in the range. To do this, copy the current cell, then Paste Special and choose Formulas and paste into the other cells in the range.

An excellent tutorial is at MREXCEL.COM, and thanks to that site for this knowledge and info.

Posted under Excel, Microsoft, Office

The redistributable package of Adobe Reader 9.1, without Adobe AIR or Download Manager bundled. This is the simple Reader-only package installer, no Internet connection needed once it is downloaded.

Find all current special offers on Adobe products.

Download

…

Adobe Download: Adobe Reader 9.1

If there is ever a problem when a PDF document is viewed, such as an error generated by Adobe or a failure to print the PDF file, then reinstalling the program is the best option. To do this, simply:

1. Uninstall any currently installed “Adobe Acrobat Reader” programs in the Control Panel’s Add/Remove programs (in Windows Vista and Windows 7 it is called “Programs and Features”).
2. If there are problems uninstalling Acrobat, such as an error such as “THE PATCH PACKAGE COULD NOT BE OPENED. Verify the patch package exists and you can access it, or contact the application vendor.” then do the following sub-routine:
   1. Download Microsoft’s Clean Up Utility.
   2. Run it to install the Clean Up program.
   3. Now run the Clean Up Utility program by clicking Start > All Programs > Windows Install Clean Up
   4. In the list of program that the utility offers fins Acrobat Reader, click once on it to select its line, then click the Remove button.
   5. Download and install Acrobat Reader from the link provided above.
   6. Once it is installed, now uninstall it in the Control Panel’s Add/Remove programs (in Windows Vista and Windows 7 it is called “Programs and Features”).
3. Install the Acrobat program after downloading it from the link above. The program has been “reinstalled” now. This reinstallation takes care of most problems that can occur in Reader, and it’s plugin / add-on for Mozilla Firefox and Internet Explorer.

There have been some mentions of an Adobe Cleanup Tool or Adobe Uninstall Tool made to uninstall Reader manually, but these are still unavailable from the Adobe website to the public. Perhaps their technical support staff can provide the utility if a customer contacts them, as one blogger stated.

Posted under Browsers, Downloads, Freeware, Microsoft

When running the SP3 install from the command line, choose the following options:

---------------------------
Service Pack 3 Setup
---------------------------
AVAILABLE SWITCHES:
[/help] [/quiet] [/passive] [/norestart] [/forcerestart] [/warnrestart] [/promptrestart] [/overwriteoem] [/nobackup] [/forceappsclose] [/integrate:] [/d:] [/log:]

/help Displays this message

SETUP MODES

/quiet Quiet mode (no user interaction or display)
/passive Unattended mode (progress bar only)

RESTART OPTIONS

/norestart Do not restart when installation is complete
/forcerestart Restart after installation
/warnrestart[:] Warn and restart automatically if required (default timeout 30 seconds)
/promptrestart Prompt if restart is required

SPECIAL OPTIONS

/overwriteoem Overwrite OEM files without prompting
/nobackup Do not backup files needed for uninstall
/forceappsclose Force other programs to close when the computer shuts down
/integrate: Integrate this software update into
/d: Back up files into
/log: Create log file at

****
My Install
Command line:
D:\WindowsXP-KB936929-SP3-x86-ENU /nobackup /quiet /forcerestart /forceappsclose

Posted under Microsoft

In order to make Windows XP ignore new wireless networks, there must be some sort of registry tweak or something, right? There must be some way to force the manual setup of new wireless network connections in Windows, right? Let’s find out… After a bit of Googling came up with these:

http://antivirus.about.com/od/securitytips/ht/wirelessconn.htm
This one may be true, but on the system I checked the checkbox mentioned was not ticked.  Not to mention, this does not keep the wireless adapter from finding, or scanning for, new wireless networks and reporting that they are in view.

Posted under Microsoft, Network, Wireless