Jagadeeps
asked on
Powershell Script to Create DB Connection and retrieve data
Need help in establishing OLEDB connection to the database, i am using the below script to connect to a oracle database, When i run the script the output is not showing all the records/ data. Enclosed my output window at the bottom.
[System.Reflection.Assembl y]::LoadWi thPartialN ame("Syste m.Data.Ora cleClient" )
$connectionString = "Data Source=(DESCRIPTION=(ADDRE SS_LIST=(A DDRESS=(PR OTOCOL=TCP )(Host=XXX XXXX)(Port =1535)))(C ONNECT_DAT A=(SID=ABC D)));User ID=giltest;Password=XXXXXX XX"
$connection = New-Object System.Data.OracleClient.O racleConne ction($con nectionStr ing)
$queryString = "SELECT PRODUCT_NAME FROM PRODUCTS"
$command = new-Object System.Data.OracleClient.O racleComma nd($queryS tring, $connection)
$connection.Open()
$productNames = $command.ExecuteScalar();
write-host "List of the Products:" $productNames | ft
$connection.Close()
[System.Reflection.Assembl y]::LoadWi thPartialN ame("Syste m.Data.Ora OLEDB.Orac le")
[System.Reflection.Assembl
$connectionString = "Data Source=(DESCRIPTION=(ADDRE
$connection = New-Object System.Data.OracleClient.O
$queryString = "SELECT PRODUCT_NAME FROM PRODUCTS"
$command = new-Object System.Data.OracleClient.O
$connection.Open()
$productNames = $command.ExecuteScalar();
write-host "List of the Products:" $productNames | ft
$connection.Close()
[System.Reflection.Assembl
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Scalar returns only one data while reader returns multiple data