Get-OdbcDriver
Retrieves one or more installed ODBC drivers from the system that match the value passed to the Name and Platform parameters. If the Name parameter is not specified, the default is to match all driver names. If no parameters are provided, retrieves all ODBC drivers installed on the system.
Syntax
Get-OdbcDriver
[[-Name] <String>]
[-AsJob]
[-CimSession <CimSession>]
[-Platform <String>]
[-ThrottleLimit <Int32>]
Description
For more information about ODBC and drivers, see Microsoft Open Database Connectivity (ODBC)http://msdn.microsoft.com/en-us/library/ms710252.aspx and Drivershttp://msdn.microsoft.com/en-us/library/ms715383.aspx.
Examples
1:
PS C:\> Get-OdbcDriver
This command gets all installed ODBC drivers (both 32-bit and 64-bit):
2:
PS C:\> Get-OdbcDriver "SQL Server Native Client 10.0" -Platform 32-bit
This command gets the driver named as "SQL Server Native Client 10.0" on the 32-bit platform:
3:
PS C:\> Get-OdbcDriver -Name "SQL Server*" -Platform 64-bit
This command gets all installed ODBC drivers with name beginning with "SQL Server" under the 64-bit platform:
4:
PS C:\> $driverArray = Get-OdbcDriver
This command is similar to Example 1, but it saves the outputted driver object into a PowerShell variable for future use:
Parameters
-AsJob
ps_cimcommon_asjob
Type: | SwitchParameter |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-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-CimSessionhttp://go.microsoft.com/fwlink/p/?LinkId=227967 or Get-CimSessionhttp://go.microsoft.com/fwlink/p/?LinkId=227966 cmdlet. The default is the current session on the local computer.
Type: | CimSession |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-Name
Specifies one or more ODBC drivers by driver name. You can use wildcard characters. The default is to return all ODBC drivers.
Type: | String |
Position: | 1 |
Default value: | None |
Required: | False |
Accept pipeline input: | True |
Accept wildcard characters: | True |
-Platform
The platform architecture of the ODBC driver. Possible values are '32-bit', '64-bit' or 'All'. The default is 'All'. This is the platform architecture on the remote machine if this command is executed in a remote CIM session.
Type: | String |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | True |
Accept wildcard characters: | False |
-ThrottleLimit
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.
Type: | Int32 |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
Outputs
Related Links
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for