testps

Function Test-ODBCConnection { 
    [CmdletBinding()] 
    param( 
        [Parameter(Mandatory=$True, 
                    HelpMessage="DSN name of ODBC connection")] 
                    [string]$DSN 
    ) 
    $conn = new-object system.data.odbc.odbcconnection 
    $conn.connectionstring = "(DSN=$DSN)" 
     
    try { 
        if (($conn.open()) -eq $true) { 
            $conn.Close() 
            $true 
        } 
        else { 
            $false 
        } 
    } catch { 
        Write-Host $_.Exception.Message 
        $false 
    } 
}