How do I suppress PowerShell script block errors?

Question

Below is a simple script block, the script block works. However, I would like to suppress any errors that the script block would generate.

$Name = 'TEST'
$SB = { param ($DSNName) ;
    $conn = new-object system.data.odbc.odbcconnection  
    $conn.ConnectionString = ('DSN='+ $DSNName) 
    $conn.open() 
    $ConState = $conn.State
    $conn.Close() 
    $ConState
}
$test = Start-job -scriptblock $SB -args $Name -RunAs32 -ErrorAction Stop | wait-job | receive-job

What I am trying to get out of this is a simple test for a 32bit ODBC connection. If the connection fails the connection state will remain closed but I also get an exception error I would like to suppress

Exception calling "Open" with "0" argument(s): "ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified" + CategoryInfo : NotSpecified: (:) [], MethodInvocationException + FullyQualifiedErrorId : OdbcException + PSComputerName : localhost

If I pipe to out-null my $test variable is empty. When I use a valid DSN Name everything works as desired.

... and OP will never learn error handling. This is a poor suggestion to me. Hiding errors is not a good fashion. — sodawillow
– sodawillow, Commented Oct 5, 2015 at 17:24

Alexander Obersht · Accepted Answer · 2015-10-04 22:03:45Z

1

You could use try..catch:

try {
    $test = Start-job -scriptblock $SB -args $Name -RunAs32 -ErrorAction Stop | wait-job | receive-job
catch [System.Management.Automation.MethodInvocationException] {
    # Do nothing here if you want to suppress the exception completely.
    # Although redirecting it to a log file may be a better idea, e.g.
    # $Error[0] | Out-File -FilePath "script.log"
}

answered Oct 4, 2015 at 22:03

Alexander Obersht

3,2832 gold badges25 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How do I suppress PowerShell script block errors?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related