When you access a database, the result is not automatically wrapped as objects so you cannot pipe the result into other cmdlets like Sort-Object or Group-Object. You can with PowerShell v.2. Here is a sample based on a previous tip (refer to the previous tip regarding general database access):
$objConnection = New-Object -comobject ADODB.Connection
$objConnection.Open("myDB")
$objRS = $objConnection.Execute("SELECT * FROM Kunden")
while ($objRS.EOF -ne $True) {
$hash = @{}
foreach ($field in $objRS.Fields) {
$hash.$($field.name) = $field.value
}
New-Object PSObject -property $hash
$objRS.MoveNext()
}
The point which you should review occurs inside the while loop. For each recordset, an empty hash table is created and then filled with the fields and field values. In PowerShell v.2, New-Object can convert a hash table into a real object, which is then output. As you see, all database records surface as real objects, and each table column becomes an object property.
ReTweet this Tip!
Posted
Dec 21 2009, 08:00 AM
by
ps1