Newbie

Ivang, thanks I already figure that out. I'm stuck with setting the MTDBdgtSales as the Scale Max value. I'll ready JuanC post again.

ok i figure out why i got the missing ISAM message. I had to change directory to where the Access db locate to run the script. Now I have a new problem: when I "select * from Customer" it works fine. when I "select * from Customer where company = wood" i get this message: Invoke-Sql : No value given for one or more required parameters??? thanks

Thank you all for the input. Here is what I did and the result: Start - All Programs - PowerGadgets - Windows PowerShell with PowerGadgets a Windows PowerShell with PowerGadgets open, I copy the script and select >-,edit,paste to paste the script and hit enter here is the script: invoke-sql -connection "Provider=Microsoft.Jet.OLEDB.4.0;DataSource=\\TestLocation\Customer\Customer.mdb" -sql "select company,Sales,Budget from Orders where company=wood" here is the result: Invoke-Sql : Could not find installable ISAM. At line:1 char:11 + invoke-sql -connection "Provider=Microsoft.Jet.OLEDB.4.0;DataSource=\\TestLocation\Customer\Customer.mdb" -sql "select company,Sales,Budget from Orders where company=wood" We just install the trial version software to see if it work for us. So I don't really know much about the software. Sounds like my computer missing something (ISAM)? Any idea? Thank you all

Hello All, I'm trying to create a Vertical Gauge chart type using through the PowerGadgets UI. The data is in an Access db locate on the network location. Here are the steps: 1. Launch PowerGadgets 2. Vertical Gauge, Next 3. User Windows PowerShell 4. in the PowerShell Script, I enter the following: invoke-sql -connection "Provider=Microsoft.Jet.OLEDB.4.0;DataSource=\\TestLocation\Customer\Customer.mdb" -sql "select company,Sales,Budget from Orders where company=wood" | out-gauge -MainValue {$_.Sales} -MainScale_Max {$_.Budget} -refresh 0:0:1 when I hit test the following show in the result: The term 'invoke-sql' is not recognized as a cmdlet, function, operable program, or script file. Verify the term and try again. At line:1 char:11+ invoke-sql <<<< -connection "Provider=Microsoft.Jet.OLEDB.4.0;DataSource=\\TestLocation\Customer\Customer.mdb" -sql The term 'out-gauge' is not recognized as a cmdlet, function, operable program, or script file. Verify the term and try again. At line:2 char:73+ "select company,Sales,Budget from Orders where company=wood" | out-gauge <<<< -MainValue {$_.Sales} -MainScale_Max {$_.Budget} -refesh 0:0:1 Can you please tell me what is wrong with the syntax? Your help/suggestion is greatly appreciated.