< Back
Get-OdbcDriver
Post
NAME Get-OdbcDriver
SYNOPSIS
Gets installed ODBC drivers.
SYNTAX
Get-OdbcDriver [[-Name] <String>] [-CimSession <CimSession[]>] [-Platform {32-bit | 64-bit | All}] [-ThrottleLimit <Int32>] [<CommonParameters>]
DESCRIPTION
The Get-OdbcDriver cmdlet gets installed Open Database Connectivity (ODBC) drivers from the computer. Specify values for the Name and Platform
parameters. If you do not specify a value for Name, the cmdlet gets drivers that have any driver name. If you do not specify any parameters, the cmdlet
gets all ODBC drivers installed on the computer.
For more information about ODBC and drivers, see Microsoft Open Database Connectivity (ODBC) (http://msdn.microsoft.com/en-us/library/ms710252.aspx) and
Drivers (http://msdn.microsoft.com/en-us/library/ms715383.aspx) on the Microsoft Developer Network.
PARAMETERS
-Name [<String>]
Specifies the name of a driver. You can use wildcard characters to specify more than one driver. This cmdlet gets one or more ODBC drivers that this
parameter specifies. If you do not specify this parameter, this cmdlet gets all ODBC drivers.
Required? false
Position? 1
Default value none
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? false
-Platform [<String>]
Specifies the platform architecture. This cmdlet gets ODBC drivers that belong to the architecture that this parameter specifies. The acceptable
values for this parameter are:
-- 32-bit
-- 64-bit
-- All
The default value is All. If you run this cmdlet in a remote CIM session, this parameter refers to the platform architecture on the remote computer.
Required? false
Position? named
Default value none
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? false
-CimSession [<CimSession[]>]
Runs the cmdlet in a remote session or on a remote computer. Enter a computer name or a session object, such as the output of a New-CimSession or
Get-CimSession cmdlet. The default is the current session on the local computer.
Required? false
Position? named
Default value none
Accept pipeline input? false
Accept wildcard characters? false
-ThrottleLimit [<Int32>]
Specifies the maximum number of concurrent operations that can be established to run the cmdlet. If this parameter is omitted or a value of 0 is
entered, then Windows PowerShell???? calculates an optimum throttle limit for the cmdlet based on the number of CIM cmdlets that are running on the
computer. The throttle limit applies only to the current cmdlet, not to the session or to the computer.
Required? false
Position? named
Default value none
Accept pipeline input? false
Accept wildcard characters? false
<CommonParameters>
This cmdlet supports the common parameters: Verbose, Debug,
ErrorAction, ErrorVariable, WarningAction, WarningVariable,
OutBuffer, PipelineVariable, and OutVariable. For more information, see
about_CommonParameters (https:/go.microsoft.com/fwlink/?LinkID=113216).
INPUTS
OUTPUTS
Microsoft.Management.Infrastructure.CimInstance#MSFT_OdbcDriver[]
Example 1: Get all installed ODBC drivers
PS C:\\> Get-OdbcDriver
This command gets all installed ODBC drivers. The cmdlet gets both 32-bit and 64-bit drivers.
Example 2: Get a driver on the 32-bit platform by using a name
PS C:\\> Get-OdbcDriver -Name "SQL Server Native Client 10.0" -Platform "32-bit"
This command gets the driver named SQL Server Native Client 10.0 on the 32-bit platform.
Example 3: Get ODBC drivers that begin with a specified string on the 64-bit platform
PS C:\\> Get-OdbcDriver -Name "SQL Server*" -Platform "64-bit"
This command gets installed ODBC drivers that have a name that starts with SQL Server on the 64-bit platform.
Example 4: Get all ODBC drivers
PS C:\\> $DriverArray = Get-OdbcDriver
This command gets all installed ODBC drivers, and then stores them in the $DriverArray variable for future use.
RELATED LINKS
Set-OdbcDriver
SYNOPSIS
Gets installed ODBC drivers.
SYNTAX
Get-OdbcDriver [[-Name] <String>] [-CimSession <CimSession[]>] [-Platform {32-bit | 64-bit | All}] [-ThrottleLimit <Int32>] [<CommonParameters>]
DESCRIPTION
The Get-OdbcDriver cmdlet gets installed Open Database Connectivity (ODBC) drivers from the computer. Specify values for the Name and Platform
parameters. If you do not specify a value for Name, the cmdlet gets drivers that have any driver name. If you do not specify any parameters, the cmdlet
gets all ODBC drivers installed on the computer.
For more information about ODBC and drivers, see Microsoft Open Database Connectivity (ODBC) (http://msdn.microsoft.com/en-us/library/ms710252.aspx) and
Drivers (http://msdn.microsoft.com/en-us/library/ms715383.aspx) on the Microsoft Developer Network.
PARAMETERS
-Name [<String>]
Specifies the name of a driver. You can use wildcard characters to specify more than one driver. This cmdlet gets one or more ODBC drivers that this
parameter specifies. If you do not specify this parameter, this cmdlet gets all ODBC drivers.
Required? false
Position? 1
Default value none
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? false
-Platform [<String>]
Specifies the platform architecture. This cmdlet gets ODBC drivers that belong to the architecture that this parameter specifies. The acceptable
values for this parameter are:
-- 32-bit
-- 64-bit
-- All
The default value is All. If you run this cmdlet in a remote CIM session, this parameter refers to the platform architecture on the remote computer.
Required? false
Position? named
Default value none
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? false
-CimSession [<CimSession[]>]
Runs the cmdlet in a remote session or on a remote computer. Enter a computer name or a session object, such as the output of a New-CimSession or
Get-CimSession cmdlet. The default is the current session on the local computer.
Required? false
Position? named
Default value none
Accept pipeline input? false
Accept wildcard characters? false
-ThrottleLimit [<Int32>]
Specifies the maximum number of concurrent operations that can be established to run the cmdlet. If this parameter is omitted or a value of 0 is
entered, then Windows PowerShell???? calculates an optimum throttle limit for the cmdlet based on the number of CIM cmdlets that are running on the
computer. The throttle limit applies only to the current cmdlet, not to the session or to the computer.
Required? false
Position? named
Default value none
Accept pipeline input? false
Accept wildcard characters? false
<CommonParameters>
This cmdlet supports the common parameters: Verbose, Debug,
ErrorAction, ErrorVariable, WarningAction, WarningVariable,
OutBuffer, PipelineVariable, and OutVariable. For more information, see
about_CommonParameters (https:/go.microsoft.com/fwlink/?LinkID=113216).
INPUTS
OUTPUTS
Microsoft.Management.Infrastructure.CimInstance#MSFT_OdbcDriver[]
Example 1: Get all installed ODBC drivers
PS C:\\> Get-OdbcDriver
This command gets all installed ODBC drivers. The cmdlet gets both 32-bit and 64-bit drivers.
Example 2: Get a driver on the 32-bit platform by using a name
PS C:\\> Get-OdbcDriver -Name "SQL Server Native Client 10.0" -Platform "32-bit"
This command gets the driver named SQL Server Native Client 10.0 on the 32-bit platform.
Example 3: Get ODBC drivers that begin with a specified string on the 64-bit platform
PS C:\\> Get-OdbcDriver -Name "SQL Server*" -Platform "64-bit"
This command gets installed ODBC drivers that have a name that starts with SQL Server on the 64-bit platform.
Example 4: Get all ODBC drivers
PS C:\\> $DriverArray = Get-OdbcDriver
This command gets all installed ODBC drivers, and then stores them in the $DriverArray variable for future use.
RELATED LINKS
Set-OdbcDriver