Error when trying to call Oracle.DataAccess.Client.OracleDataAdapter.Fill()
$asm = [System.Reflection.Assembly]::LoadWithPartialName(“Oracle.DataAccess”)
$userName = "foo"
$tnsDbName = "bar"
$pass = "foobar"
$connectionString = "User Id=$userName;Password=$pass;Data Source=$tnsDbName"

$q = @"
SELECT * FROM blah WHERE blar = '5848752'
"@

$cstr = $connectionString
$conn= New-Object Oracle.DataAccess.Client.OracleConnection($cstr)
$conn.open()
$adapter = New-Object Oracle.DataAccess.Client.OracleDataAdapter($q,$conn)
$dataset = New-Object Data.DataSet
$adapter.Fill($dataset)
$dataset.Tables[0]

PS H:> $asm.GetName()

Version        Name
-------        ----
10.2.0.100     Oracle.DataAccess

PS H:> $adapter.SelectCommand.Connection | fl ClientID,ConnectionTimeout,ServerVersion,State


ClientId          :
ConnectionTimeout : 15
ServerVersion     : 10.2.0.4.0
State             : Open