Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Get-OdbcDriver

Updated: October 17, 2013

Applies To: Windows 8.1, Windows PowerShell 4.0, Windows Server 2012 R2

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

Parameter Set: Get0
Get-OdbcDriver [[-Name] <String> ] [-AsJob] [-CimSession <CimSession> ] [-Platform <String> ] [-ThrottleLimit <Int32> ] [ <CommonParameters>]




Detailed Description

For more information about ODBC and drivers, see Microsoft Open Database Connectivity (ODBC) and Drivers.

Parameters

-Name<String>

Specifies one or more ODBC drivers by driver name. You can use wildcard characters. The default is to return all ODBC drivers.


Aliases

none

Required?

false

Position?

1

Default Value

none

Accept Pipeline Input?

true (ByPropertyName)

Accept Wildcard Characters?

true

-Platform<String>

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.


Aliases

none

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

true (ByPropertyName)

Accept Wildcard Characters?

false

-AsJob

Runs the cmdlet as a background job. Use this parameter to run commands that take a long time to complete. The cmdlet immediately returns an object that represents the job and then displays the command prompt. You can continue to work in the session while the job completes. To manage the job, use the *-Job cmdlets. To get the job results, use the Receive-Job cmdlet. For more information about Windows PowerShell® background jobs, see about_Jobs.


Aliases

none

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

false

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.


Aliases

none

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.


Aliases

none

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, -OutBuffer, and -OutVariable. For more information, see    about_CommonParameters.

Inputs

The input type is the type of the objects that you can pipe to the cmdlet.

Outputs

The output type is the type of the objects that the cmdlet emits.

  • Microsoft.Management.Infrastructure.CimInstance#MSFT_OdbcDriver[]

Examples

 

This command gets all installed ODBC drivers (both 32-bit and 64-bit):


PS C:\> Get-OdbcDriver

 

This command gets the driver named as "SQL Server Native Client 10.0" on the 32-bit platform:


PS C:\> Get-OdbcDriver "SQL Server Native Client 10.0" -Platform 32-bit

 

This command gets all installed ODBC drivers with name beginning with "SQL Server" under the 64-bit platform:


PS C:\> Get-OdbcDriver -Name "SQL Server*" -Platform 64-bit

 

This command is similar to Example 1, but it saves the outputted driver object into a PowerShell variable for future use:


PS C:\> $driverArray = Get-OdbcDriver

Related topics

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.