Oracle.DataAccess with Powershell
967931Oct 12 2012 — edited Oct 12 2012Hi all,
I'm using powershell for querying all our oracle instances and for this purpose I use Oracle.DataAccess. Before I upgraded to Windows 7 64bit from 32bit it had worked fine but now I get this message:
+[Reflection.Assembly]::LoadFile("c:\oracle\product\11.2.0\client_1\ODP.NET\bin\2.x\Oracle.DataAccess.dll")+
GAC Version Location
False v2.0.50727 c:\oracle\product\11.2.0\client_1\ODP.NET\bin\2.x\Oracle.DataAccess.dll
I have tried different versions of ODAC or Oracle clients but no success, still not properly loaded neccessary library or mismatch in versions. Can you please help me which combination should I use (ora client 32/64bit, ODAC, ...)?
Thank you in advance.
Jan