Get-SasOleDbConnection

NAME
    Get-SasOleDbConnection

SYNOPSIS
    Gets a OleDb database connection to a local or 
    remote SAS workspace.

SYNTAX
    Get-SasOleDbConnection [-Workspace] <PSObject> 
    [<CommonParameters>]

DESCRIPTION

PARAMETERS
    -Workspace <PSObject>
        SAS.Workspace object

        Required?                    true
        Position?                    0
        Default value                
        Accept pipeline input?       true (ByValue)
        Accept wildcard characters?  false

    <CommonParameters>
        This cmdlet supports the common parameters: 
    Verbose, Debug,
        ErrorAction, ErrorVariable, WarningAction, 
    WarningVariable,
        OutBuffer and OutVariable. For more 
    information, see 
        about_CommonParameters 
    (http://go.microsoft.com/fwlink/?LinkID=113216).

INPUTS

OUTPUTS

NOTES

    --------------  Example 1  --------------

    PS C:\> $ws = Connect-SasWorkspaceLocal
    $conn = Get-SasOleDbConnection $ws
    $conn.Open()
    # use connection e.g. for OleDbCommand
    $conn.Close()

    Get the OleDb connection from the workspace and 
    use it. For uses of the oledb connection see SAS 
    documentation "SAS(R) 9.3 Providers for OLE DB: 
    Cookbook" (http://support.sas.com/documentation/c
    dl/en/oledbpr/63701/HTML/default/viewer.htm#n0hei
    gqkqll8u9n1d9beeqkh0n2f.htm)

RELATED LINKS