use the following connection string in VB Macro, Excel 2007 and I use 32 bit Windows Xp
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
Please Login or Register to view this content.
How do I need to modify the code so it works in windows 7 64 bit OS also"Connection not open"
I used Windows "ActiveX Data Objects 2.8 Library" as reference in excel 2007 macro in my XP desktop
Thanks in advance