Wednesday, 25 July 2018

Microsoft Excel's insert column option is disabled, after right clicking. How do I enable it?

The following steps resolve the issue:
1. Close all open Excel windows
2. In Windows Explorer, go to directory "%appdata%\Microsoft\Excel"
3. Rename the file:  Excel15.xlb --> Excel15.old

Monday, 4 June 2018

Difference between vSphere, ESXi and vCenter

VMware Inc. is a software company that develops many suites of software products specially for providing various virtualization solutions. There are many cloud productsdatacenter productsdesktop products and so on. VMware has moved from being just a Virtualization company, though it started as one.
VMware Vsphere or simply known as vSphere is a software suite that comes under data center product. vSphere is like Microsoft Office suite which has many softwares like MS Office, MS Excel, MS Access and so on. Like Microsoft Office, vSphere is also a software suite that has many software components like vCenter, ESXi, vSphere client and so on. So, the combination of all these software components is vSphere. vSphere is not a particular software that you can install and use, “it is just a package name which has other sub components”.
ESXi, vSphere client and vCenter are components of vSphere. ESXi server is the most important part of vSphere. ESXi is the virtualization server. It is type 1 hypervisor. All the virtual machines or Guest OS are installed on the ESXi server. To install, manage and access those virtual servers which sit on top of ESXi server, you will need other part of vSphere suit called vSphere client or vCenter. Now, vSphere client allows administrators to connect to ESXi servers and access or manage virtual machines. vSphere client is installed on the client machine (e.g. Administrator’s laptop). It can also be installed on the same physical server where ESXi is installed. The vSphere client is used from client machine to connect to ESXi server and do management tasks. So now what is vCenter? Why we need it? Try cloning existing virtual machine using just a vSphere client without vCenter server and you will see it is impossible.
vCenter server is similar to vSphere client but it’s a software with more power. vCenter server is installed on Windows Server or Linux Server or desktop/laptop. VMware vCenter server is a centralized management application that lets you manage virtual machines and ESXi hosts centrally. vSphere client is used to access vCenter Server and ultimately manage ESXi servers. vCenter server is compulsory for enterprises to have enterprise features like vMotion, VMware High Availability, VMware Update Manager and VMware Distributed Resource Scheduler (DRS). For example, you can easily clone existing virtual machine in vCenter server. So vCenter is another important part of vSphere package. You have to buy vCenter license separately.
vSphere is a product suite, ESXi is a hypervisor installed on a physical machine.
vSphere Client is installed on laptop or desktop PC and is used to access ESXi Server to install and manage virtual machines on ESXi server.
vCenter server is installed as virtual machine on top of ESXi server. vCenter server can also be installed on different standalone physical server, but why not virtualize it too right? vCenter server is a vSphere component which is mostly used in large environment where there are many ESXi servers and dozens of virtual machines. The vCenter server is also accessed by vSphere client for management purpose. So, vSphere client is used to access ESXi server directly in small environment. In larger environment, vSphere client is used again to access vCenter server which ultimately manages ESXi server.
Virtualizing the vCenter server.
If the ESXi host that houses the virtual vCenter server becomes inaccessible, then the services are interrupted and you cannot connect to the server. This will cause all sorts of headaches. The only solution is to log into each ESX host and see where the vcenter server is present. You can build a physical vCenter server and domain controller to alleviate this issue. Although you can virtualize any application, I do not think all applications should be. Just some admin advice and experience when planning your virtual environment. However, this can be addresses by getting one or two extra hosts so vcenter can restart itself on another host.

Wednesday, 30 May 2018

Lenovo compatible to AHCI Change (Install AHCI driver install)

This section assumes to use Internet Explorer and Windows Explorer.
Download and unpack the package should be done under a Windows OS. Installation requires a USB Floppy Disk drive and a floppy disk.
[Downloading files]
  1. Click once on the underlined file name. Once this is done, some pop-up windows will appear.
  2. Follow the instructions on the screen.
  3. In the window to choose Run or Save, click the Save button.
  4. Choose the folder you would like to download the file to and click the Save button. A different window will appear and the download will begin and complete. Once the download has completed, there may or may not be a message stating that the download completed successfully.
[Extracting files]
  1. Make sure to be logged on with an administrator account.
  2. Locate the folder where the file was downloaded.
  3. Locate the file that was downloaded and double-click it.
  4. Follow the instructions on the screen.
  5. In the Select Destination Location window, click Next. If you would like to select a different folder, click Browse.
  6. In the Ready to Install window, click Install. All the necessary files will be extracted to the folder selected in the step 9.
  7. Uncheck the checkbox next to Install ..... now, and then click Finish to complete extraction.
Delete the file saved in the step 4.
[Installation]
  1. Attach a USB floppy disk drive and set the driver floppy disk to your ThinkPad.
  2. Set the Windows 7/Vista installation disc on optical drive.
  3. Power on the ThinkPad and start installation.
  4. Press F6 key to select an external hard disk driver before continue installation.
  5. Select AMD AHCI Compatible RAID Controller-x86 platform then Enter.
  6. Follow the Windows 7/Vista install instruction and complete installation.
[Update Install]
  1. Start Windows 7/Vista.
  2. Click Start and Control Panel.
  3. Click Performance and Maintenance and System.
  4. Click Hardware tab.
  5. Click Device Manager button.
  6. Double-click the IDE ATA/ATAPI Controllers on Device Manager.
  7. Double-click Standard AHCI1.0 Serial ATA Controller.
  8. Click Driver tab.
  9. Click Update Driver button.
  10. Select Browse my computer for driver software button.
  11. Click Browse, select driver locations.
    • For Windows 7 32 bit Defaults locations "C:\DRIVERS\WIN\AMD_AHCI\Win7x86
    • For Windows 7 64 bit Defaults locations "C:\DRIVERS\WIN\AMD_AHCI\Win7x64
    • For Windows Vista 32 bit Defaults locations "C:\DRIVERS\WIN\AMD_AHCI\LHx86
    • For Windows Vista 64 bit Defaults locations "C:\DRIVERS\WIN\AMD_AHCI\LHx64
  12. Check Include subfolder.
  13. Click Next button. The driver installation starts.
  14. Click Finish button when the installation completes.
  15. Click Close button.
Determining which version is installed
[Driver]
  1. Click Start.
  2. Right-click Computer, and then click Properties.
  3. At the left pane, click Device Manager.
  4. Double-click the AHCI SCSI and RAID controllers category.
  5. Double-click either of the following adapters. AMD AHCI Compatible RAID Controller
  6. Click the Driver tab.
  7. Check Driver Version. 
 https://download.lenovo.com/ibmdl/pub/pc/pccbbs/mobiles/85s801ww.txt

https://download.lenovo.com/ibmdl/pub/pc/pccbbs/mobiles/85s801ww.exe

Friday, 27 April 2018

"save as" pop up box does not allow me to save the document.

Solution:
The default "Save As" dialog in Acrobat DC is different than the dialog that you've had in earlier releases of Acrobat, it also allows you to save to the cloud and previous locations you've saved files to. It is possible that when Acrobat tries to connect to "the cloud", it runs into problems. You may want to try to turn this feature off to see if that brings your save as dialog back: Open up Acrobat's preferences, then go to the "General" category and deselect "Show online storage when saving files":
 

Tuesday, 7 November 2017

How do I open it .emz files?

Regarding .EMZ files, they're images.  You can import them to a MS word document via Insert->Picture.

Tuesday, 31 October 2017

XStandard Zip

Overview

The Zip component provides industry-standard Zip archive functionality. It is designed to be easy to use. You can pack/unpack a file or folder with a single line of code. If you need to create or extract Zip files on the fly, this component is for you. This component can be used in environments that support COM such as Active Server Pages, Windows Scripting Host, Visual Basic, etc.

License
    Freeware
Type
    32-bit ActiveX DLL
Version
    2.5
File Name
    XZip.dll
Download Package
    x-zip.zip

Download

Download Zip Component

Visual C++ users can download header files.
Installation Instructions

    Move the dll to a directory like: C:\Program Files\XStandard\Bin\.
    Open a command prompt and cd to the directory where the dll is located.
    Type regsvr32 XZip.dll or on 64-bit OS type C:\Windows\SysWOW64\regsvr32.exe XZip.dll
    Grant "Read & Execute" file permissions on this dll to Everyone.

Note, the command prompt must be "Run as administrator" as shown in the screen shot below.

Context menu for the command prompt showing the option to run as administrator.
Uninstall Instructions

    Open a command prompt and cd to the directory where the dll is located.
    Type regsvr32 -u XZip.dll or on 64-bit OS type C:\Windows\SysWOW64\regsvr32.exe -u XZip.dll

Usage from 64-bit OS

Please see instructions for 64-bit OS usage.

Friday, 27 October 2017

Persits.MailSender 'Access is denied'

If you happen to be using the Persits mail component and you get the 'Access is denied' exception:
Persits.MailSender.4 error '800a0011'
Access is denied.
/pages/somepage.asp, line 208
You'll probably find, from the Persits support site or elsewhere, that the queue folder needs to have increased permissions. It doesn't however tell you where this is. So here is the default install path for version 4:
C:\Program Files\Persits Software\AspEmail\Queue
As far as the permissions go I have found that granting Read and Write permissions to the accessing account on that folder is sufficient. In IIS 6 the accessing account for .NET will be the identity of the App Pool assigned to the site (if you are not doing impersonation) which is the NetworkService account by default. For Classic ASP it will be the anon account (Which by default is the IUSR_xxx) for anon access or the user/group if you are doing other types of auth.