How to make the web pages load faster in IE8

Do you experience poor response/load time of your web pages in IE8. Here is what you can do to make your web page load faster in Internet Explorer 8.

This post suggest you to make the changes to the registry. Hence cautions in making the changes to registry. Before making changes to the registry, you should back up any valued data on the computer.

  1. Open Registry Editor by typing REGEDIT into the Run dialog in the start menu
  2. Browse to HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Internet Settings.
  3. Right click and create a new DWORD key and name it “MaxConnectionsPer1_0Server”
  4. Double click the key to set a value. The number 12 should be good.
  5. Right click and create a another new DWORD key and name it “MaxConnectionsPerServer”
  6. Double click on the key and set the value. The number 12 should be good.
  7. Close the Registry Editor
  8. Restart your your Internet Browser.

Hope you will see difference while browsing majority of sites on internet.

– Gangadhar Kotu


Arithmetic Operation Resulted In An Overflow

When I was executing the Stored Procs in Oracle from C# (using Oracle.DataAccess.dll – v or 11gR2 client as well), I’m receiving the below error.

“Arithmetic Operation Resulted In An Overflow.”

Couldn’t figure it out why it is happening all of sudden.Verified all the code and nothing has been changed but observed that the data in the Database has got updated.

Tried to figure it out why the data is introducing new errors and understood that the OracleClient is using Int32 as it’s parameter to convert the data from Cursor to DataTable.

Possible Solutions:

1. Data in the column coming more than Int32 value.
2. Length of the number Data in the column is more than 28 digits (excluding the decimal point), means 99999.999 is 8 digits.
3. Length of the decimal values are more than 16 digits. (eg., 123.12345678901234567)

FYI, stack trace:

at Oracle.DataAccess.Types.DecimalConv.GetDecimal(IntPtr numCtx)
at Oracle.DataAccess.Client.OracleDataReader.GetDecimal(Int32 i)
at Oracle.DataAccess.Client.OracleDataReader.GetValue(Int32 i)
at Oracle.DataAccess.Client.OracleDataReader.GetValues(Object[] values)
at System.Data.ProviderBase.DataReaderContainer.CommonLanguageSubsetDataReader.GetValues(Object[] values)
at System.Data.ProviderBase.SchemaMapping.LoadDataRow()
at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)
at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
at System.Data.Common.DataAdapter.Fill(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
at System.Data.Common.LoadAdapter.FillFromReader(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
at System.Data.DataTable.Load(IDataReader reader, LoadOption loadOption, FillErrorEventHandler errorHandler)
at System.Data.DataTable.Load(IDataReader reader)
at DataHelper.RetrieveOutputCursor(OracleCommand cmd, Hashtable htResults) in C:\DataHelper.cs:line 294
at DataHelper.ExecuteProcedureReturnDataSet(String procName, Hashtable spParams) in C:\DataHelper.cs:line 208

Check it out for this possibility as well. ūüôā

– Gangadhar Kotu

Unable to query host name with ipconfig and no internet

I was browsing multiple sites over Internet and clicked on miserably known links. I would have clicked on some unknown links in between. After a while, the browser got closed automatically. It had given me some message clearly. But thinking of nothing happened.

Next day morning, I had opened the system but it is running pretty slowly and could scan my system using McAfee. This had thrown a bigger message to me that your system is infected by Virus.

You could guess what would have happened and how much bigger damage would it be. ūüė¶ ¬†VIRUS, VIRUS and the Dangerous….¬†!B&threatid=2147646431

The result is my system (Windows XP) got infected with virus (Backdoor:Win32/Smadow.gen!B, Trojan:Win32/FakeSysdef) and the damage is huge. Also Microsoft had stopped support on Windows XP couple of months ago.

Tension, tension, tension as this system has got lots of data and applications.

The damage is summarized below:

  1. Removed McAfee specific dll (OC****.dll), hence can’t scan my system.
  2. System is pretty slow.
  3. Am sure it would have impacted some system dlls but not sure what are they?
  4. Don’t even know what other damage it had done.

What did I do to recover the damage?

  1. Uninstalled McAfee Enterprise (all features) but McAfee Agent. It is not uninstalling with an error message that there are applications running by using Agent. This doesn’t impact anything to move forward to install another Anti-Virus Software.
  2. ¬†Installed McAfee again to see whether it can proceed anyways. I’m failed get McAfee working on my machine with multiple tries. – Spent 5-6 hours on this to understand why it is not installing again.
  3. Lost hopes on McAfee and started thinking of get another anti-virus software.
  4. After an hour or two, I remembered the suggestion from my office TSS guy. The suggestion is ‘Install Microsoft Security Essentials’ and that too it is free for use by Microsoft.
  5. I have downloaded Security Essentials from Microsoft site from another laptop. Once it is installed and ran that for FULL scan, it took around 4-5 hours.
  6. There were couple of Blackdoors/trojans on the system and the recommendation is to remove those files as they are badly impact the system.
  7. Backdoor:Win32/Smadow.gen!B – This has infected to Windows\System32\drivers\ipsec.dll (would have impacted to tcpip.sys also) and couple of .sys files from System Volume Information folder. With this, network connectivity would never happen. But no way to avoid that as it is infected file.
  8. The entries (ipsec and tcpip) would have been deleted from the registry HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\.
  9. When you do ‘ipconfig’ from command prompt.
    An Internal error occurred:The request is not supported.
    Please contact Microsoft Product Support Services
    Additional Information: Unable to query host name
  10. Trojan:Win32/FakeSysdefIt has deleted couple of files from Application data folder.
  11. I need to reinstall Windows XP SP3 as well once again.
After this, lots of trails to get the system up but not happened. I did lot many workarounds suggested by lot many folks over Internet.
  1. Uninstalled Ethernet drivers. Restarted the machine, no luck.
  2. Reinstalled Windows XP SP3. Restarted the machine, no luck.
  3. Compared with other XP laptop and understood that it has also removed tcpip.sys from Windows\System32\drivers folder. tcpip.sys is very important protocol and impacts the network in the system.
    To Correct this:-

    1. Option1 – Tried installing Microsoft Fixit from¬† This didn’t help. Then went to the below steps.
    2. Go to Control Panel
    3. Open Network connections
    4. Select ‘Internet protocol (TCP/IP)’ and uninstall. By the way, you cannot unstall as the uninstall button would be disabled here. Use the Windows Enabler tool (either from¬†or¬† Usage document would be available along with the tool.
    5. Quick brief on that, you just need to run Windows Enabler.exe, the icon sits in the System tray.
    6. After opening the network properties dialog and select the ‘Internet protocol (TCP/IP).
    7. Click on the icon from system tray and then click on ‘Uninstall’ disabled button, the tool enables button.
    8. Clik on Uninstall button. This would ask for restart of the system. After restart, it had brought back all the keys in HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\tcpip\
    9. Now, you are good that the network connectivity happens.
    10. Connect your ethernet cable to the system and could observe that the lights were blinking.
  4. To get the ipsec.sys file..
    To Correct this:-

    1. Copy ipsec.sys file from a virus-free windows XP machine. The file would be available in Windows\System32\drivers\ folder.
    2. Restart the machine.
    3. After restart, it had brought back all the keys in HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\IPSec.
    4. Now, run ipconfig and HURRAY, the IP details has come back.

Huh, tried to connect to the internet, yes, the system is getting the IP address and also connecting to Internet.

I re-ran the Anti-virus and the system is cleaned up as per the Security Essentials anti-virus. The whole process took me 3 days to get my system back to previous known status and immediately posting this for the persons like you if have an issue like this.

Now, I can happily have a nice nap. Have a good time.

~ Gangadhar Kotu

Unable to start debugging in Silverlight 3 for VS 2008

Hi All,

Following is the error I got when try to debug my sample silverlight 3 application.

“unable to start debugging.the silverlight managed debugging package isn’t installed”

At first time debugging works fine. I upgraded Silverlight 3 runtime into Silverlight 4. Then I got the above error while debugging.

That error indicates that I have the end-user runtime installed, not the developer runtime. The dev runtime is available here:

Then I have downloaded the Developer runtime for Silverlight 3. That fixes my problem of debugging but still I’m receiving the another error.

Unhandled Error in Silverlight Application
Code: 2104   
Category: InitializeError      
Message: Could not download the Silverlight application. Check web server settings.

To correct the above issue, check the below IIS settings if you are running the app from IIS and ensure to have the .xap file in the ClientBin folder of the web application.

.xaml    application/xaml+xml
.xap    application/x-silverlight-app
.xbap    application/x-ms-xbap

~ Gangadhar Kotu

How to avoid ‘Run as Administrator’ in Windows7?

Am sure most of you are frustrated to use ‘Run as Administrator’ for many tools in Windows7. Below are the steps to avoid using ‘Run as Administrator’ option for any application running in Windows 7 and let’s make the application run under administrative privileges by default.

To set this property, just right-click on any shortcut, and click the Advanced button on the Shortcut page to get to the Advanced Properties dialog.

You‚Äôll see a dialog with a checkbox for ‚ÄúRun as administrator‚ÄĚ.

Now on, the application runs under administrative privileges by default.


Gangadhar Kotu

OracleCommandBuilder.DeriveParameters doesn’t return Stored Procedure definition

We were in a situation to migrate the Oracle database from one data center to another data center. The migration activities are completed and felt it is succeeded.

We observed the existing functionality which uses OracleCommandBuilder.DeriveParameters method is not return any parameter information of the Stored Procedure we are looking for. Hence tried with multiple functionality. No luck and spend a day on this as well.

Felt like some privileges issue and contacted the DBA teams as well. Later found that the Oracle packages were in INVALID state due to migration. So, Compiled the packages and the status becomes VALID.

There you go, the functionality started working.

In this case, the packages were not in a compiled (valid) state. Once we execute the Oracle package, everything went fine.

This is one possible solution if you are facing the similar issue.

Good luck..!!

Gangadhar Kotu

How to change default environment settings in Visual Studio?

Here are the simple steps to change the default environment settings in the Visual Studio.

Use the Import and Export Setting Wizard:

1. Choose Tools -> Import and Export Settings
2. Select Reset All Settings and click Next
3. Select whether you would like to save the current settings and click Next
4. Select the settings you want to use and click Finish

Gangadhar Kotu