How to get ASP.NET 2.0 app on an x64 development machine to work with Oracle 10.2.0.2 32 bit client

I had a problem where I got a new machine. My previous workstation was XP 32bit OS, and my new machine was XP 64bit. I had installed the 32bit client, and the ODP.NET data access components, but was still getting the error:

ORA-12154: TNS:could not resolve the connect identifier specified

Even though the tnsnames.ora and sqlnet.ora files were 100% correct. I then came upon these two URL's:

1.http://www.oracle.com/technology/tech/dotnet/col/odt_faq.html (search for ORA-12154)
2.http://joeydotnet.com/blog/archive/2007/01/24/19.aspx

After that I create a metalink oracle account and my manager authorised it. I then download this patch:

10.2.0.1.0 Patch 6 (10.2.0.1.6P) 32-Bit Patch 5059238. URL: http://updates.oracle.com/ARULink/PatchDetails/process_form?patch_num=5239698

After unzipping it I made a backup of C:\oracle\product\10.2.0\client_1\bin and then copied the patch files (p5059238_10201_WINNT\5059238\files\bin) into the bin folder and overwrote the dll's already in the client bin folder

Then fired up VS 2008 and executed my web app locally and it all worked.

Let's hope this helps some others.