use the following connection string in VB Macro, Excel 2007 and I use 32 bit Windows Xp

Please Login or Register  to view this content.
Currently this connection string works perfect when I try to connect to Oracle Database from my XP 32 bit When I try to run the same code in Windows 7 64 bit OS the code throws an error

"Connection not open"
How do I need to modify the code so it works in windows 7 64 bit OS also

I used Windows "ActiveX Data Objects 2.8 Library" as reference in excel 2007 macro in my XP desktop

Thanks in advance