PoshCode Logo PowerShell Code Repository

Difference between
modified post 6666 by PRUEBA on Wed 4th Jan 15:47 and
original post 6665 by dfafadfds on Wed 4th Jan 15:44
Showold version | new version | both versions

    
11
# Load assembly
22
[System.Reflection.Assembly]::LoadWithPartialName("Oracle.DataAccess")
44
# Connection information
55
$ConnectionString = "Data Source=your_server/sid;User Id=user_name;Password=password"
77
#Standard SQL Query Syntax
88
$QueryString = "SELECT * FROM table_name WHERE #Case"
1010
$OracleConnection = New-Object Oracle.DataAccess.Client.OracleConnection($ConnectionString)
1111
$dtSet = New-Object System.Data.DataSet
1212
$OracleAdapter = New-Object Oracle.DataAccess.Client.OracleDataAdapter($QueryString, $OracleConnection)
1414
[void]$OracleAdapter.Fill($dtSet)

ContributeMost Recent Contributions (feed)

Contribute ... Next Page