Monday, March 29, 2010

Visual Studio 2008 Quick Start

Resource from Victor Chen blog

Microsoft Visual Studio 2008 is by far one of my personal favorite Integrated Development Environments (IDE). However, it is also no secret some aspects of the IDE are overly bloated and therefore take forever to load or execute. One portion that drives me crazy is the time it takes Visual Studio 2008 to load up. By default (after a standard installation), Visual Studio 2008 opens the start page, which a screen containing recently open solutions as well as links to MSDN containing latest Microsoft programming news. I never looked at the news and instead always immediately opened a solution.

Now, I have run across a setting buried deep in the options that allows this to be changed to any one of following options:

Open Home Page
Load last loaded solution
Show Open Project dialog box
Show New Project dialog box
Show empty environment
Show Start Page
I chose “Show Open Project dialog box” which for my needs makes the most sense. Nearly 95% of my time I open Visual Studio, my aim is to add new features or fix bugs. It loads blazing fast as compared to”Open Home Page” or “Show Start Page” because no overheard is required to visit the MSDN website.

To get to the dialog box, go to Tools > Options. Once in the dialog box, you go to Environment > Startup. Simply use the Dropdown Box and select your desired startup option.

If you do make a change (or have made a change prior to reading this article), what setting do you use?

Wednesday, November 18, 2009

Trying to resolve ODP error

Getting this error
The type 'Oracle.DataAccess.Client.OracleConnection' exists in both 'c:\WINDOW\assembly\GAC_32\Oracle.DataAccess\\Oracle.DataAccess.dll' and 'c:\WINDOWS\assembly\GAC\Oracle.DataAccess\\Oracle.DataAccess.dll'

It goes on for Oracle.DataAccess.Client.OracleCommand, OracleDataAccess.Client.OracleDataAdapter

Read somewhere need to ungac one of them via
gacutil /u Policy.2.102.Oracle.DataAccess

Need to run gacutil from Visual Studio 2008 command prompt

More details how to run gacutil
I believe the version numbers changed a bit with the 10.2 release. It sounds to me like you still have the old Oracle.DataAccess.dll file referenced in the GAC. What I would try is to remove all references that are in the GAC using the gacutil that comes with the .NET Framework 2.0 SDK. If you use the .NET 1.1 gacutil, you'll get an error when trying to work with the .NET 2.0 DLL's. To remove the references, you'll have to execute something like this:

REM Remove GAC Entries
gacutil /u Oracle.DataAccess
gacutil /u Policy.9.2.Oracle.DataAccess
gacutil /u Policy.10.1.Oracle.DataAccess
gacutil /u Policy.10.2.Oracle.DataAccess

This will remove all your GAC entries, including the policies.

Then, add the references from the new ODP.NET like this:

REM Update .NET GAC (1.1 and 2.0)
gacutil.exe /i \Client\\\bin\1.x\Oracle.DataAccess.dll /f
gacutil.exe /i \Client\\\bin\2.x\Oracle.DataAccess.dll /f
gacutil.exe /i \Client\\\PublisherPolicy\1.x\Policy.9.2.Oracle.DataAccess.dll
gacutil.exe /i \Client\\\PublisherPolicy\1.x\Policy.10.2.Oracle.DataAccess.dll

where = The path to your Oracle Home

These commands will add the references to the GAC for .NET 1.1 and 2.0. Also, if you have tools built with references to the previous versions, the Policy entries will direct those references to use the latest library. You may be able to omit the install of the Policy.9.2.Oracle.DataAccess.dll if you have never used the Oracle 9.2 version ODP.NET in any of your tools.

I actually got most of this procedure from an Oracle document somewhere, but I can't seem to find it right now. It might be in an FAQ somewhere...

Finally the solution for me after a week of search and destroy
Check your references in web.config of the application, or machine.config/web.config of the machine. You have references to two versions of the dll, so remove the one you are not going to use.

Thursday, November 5, 2009

how to uninstall oracle 10g from windows xp

From :

Sunday, August 14, 2005

Oracle's installation utility has a nasty habit of leaving a lot of items behind. I wrote this up to document what I've found you need to do to uninstall Oracle 10g manually. This is specific to 10g and Windows XP. Removing 9i is very similar if I remember right, but who's using 9i anymore? ;-)
The first thing you should do, is go ahead and run the installation tool to do an uninstall. It probably will leave some things behind, but it's worth running. Then go through this list and remove anything it missed. This list is detailed enough though, that I believe even if you did not run the uninstallation tool, this would fully uninstall Oracle.
The most commonly missed item is to make sure you remove everything from the GAC because the uninstaller doesn't appear to. I get to that later, but if you wanted to know the largest source of uninstallation problems, it's libraries remaining in the GAC.
After running the supplied Oracle uninstallation utility (which may or may not do some or all of the following):
Stop any Oracle services that have been left running.

Start->Settings->Control Panel->Services

Look for any services with names starting with 'Oracle' and stop them.
Run regedit and delete the following keys (some may have slightly different names in your registry):






Note that the services control panel will still show the old services until you reboot.
Delete the Oracle home directory

Delete the Oracle Program Files directory:

C:\Program Files\Oracle
Delete the Oracle Start Menu shortcuts directory:

C:\Documents and Settings\All Users\Start Menu\Programs\Oracle*

Where * indicates the name of your install. Look for and remove all Oracle directories from that location.
Remove Oracle refereces from the path. To edit your path go to:

Start->Settings->Control Panel->System->Advanced->Environment Variables

Edit both of the environment variables user PATH and system PATH. Remove any Oracle references in them.
Remove Oracle.DataAccess and any Polic.Oracle files from the GAC which is at:

There, now your system is Oracle free. If you are installing a new instance of Oracle (and not just an additional DB) I recommend you do this before any new Oracle installation.

Note: I used several other websites and searches as references when developing these steps, but I was unable to find any steps that covered all of the items for Oracle 10g so I assembled them here

Wednesday, November 4, 2009

Problem in UTF-8 support on CSV/EXCEL

It seems like everyone is having this issue. This is very common problem and i have been looking for its solution for a long time too. I have found a solution and have tested it to make sure it works for almost all languages.

This is problem with Excel NOT the data format that is exported. Here are the steps

1- download the exported CSV/XLS file from your website.
2- Open Excel 2007
3- Open a new file
4- Click the Data Menu option
5- Click "From Text" button
6- Select the file you downloaded
7- Make sure "Delimited" is selected and Press Next
8- Check the delimiter characters that you know are in your file like Comma or Tab or whatever is in your case. You can select more than one
9- Proceed to Next Step and Finich
10- Your excel file will be ready with all you data displayed correctly

I hope that helps someone who has been frustrated on this.



Tuesday, November 3, 2009

IIS 5.1 in XP PRO SP3 (Login password Popup)

Troubleshooting HTTP 401 errors in IIS

Is there an index.htm or default.htm under C:\Inetpub\www ?
If not, put one there and see what happens.


(1) Launch inetmgr and right click on site
(2) Go to Properties
(3) Go to Directory Security Tab
(4) Click on Edit under Authentication and Access Control
(5) Select checkbox that says Enable Anonymous Access

Screen shot follows :

If this doesn't work then perhaps

Check on iisstart.asp or localstart.asp, I believe the anonymous auth is disable at file level as well


Uninstall Framework 3.5, 3.0 and 2.0 and reinstalled IIS.

That is becoz IE auto login for you, mozilla won't do that.

So again make sure you enabled anonymous authentication and ensure the resource file can be read by the anonymous account, which is iusr_computername by default.