I am running the following scenario:
Two oracle databases:
Server 1 - Windows 2008 R2, 64 Bit. On it runs Oracle Enterprise Edition 11g, Release 11.2.0.3.0,64 bit Production with Partitioning, OLAP, Data Minidng and Real Application Testing Options.
Server 2 - Windows 2008 R2, 64 Bit. On it runs Oracle 11g, Release 11.2.0.3.0,64 bit.
I'm trying to use the managed driver with PowerShell 4 x86.. Here is my very simple script. The lines commented out with # are the ones with the
#[System.Reflection.Assembly]::LoadFrom("E:\oracle\instantclient_11_2\odp.net\managed\common\Oracle.ManagedDataAccess.dll")
$GG ='Data Source=DBA;User Id=usr1;Password=usr1'
#$GG ="Data Source=DBA2;User Id=usr2;Password=usr2"
$A = New-Object Oracle.ManagedDataAccess.Client.OracleConnection($GG)
$A.Open()