Export (0) Print
Expand All

Get-OdbcDriver

Windows Server 2012 R2 and Windows 8.1

Updated: June 5, 2014

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

Get-OdbcDriver

Gets installed ODBC drivers.

Syntax

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




Detailed 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.


Aliases

none

Required?

false

Position?

1

Default Value

none

Accept Pipeline Input?

true (ByPropertyName)

Accept Wildcard Characters?

true

-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.


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

Example 1: Get all installed ODBC drivers

This command gets all installed ODBC drivers. The cmdlet gets both 32-bit and 64-bit drivers.


PS C:\> Get-OdbcDriver

Example 2: Get a driver on the 32-bit platform by using a name

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


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

Example 3: Get ODBC drivers that begin with a specified string on the 64-bit platform

This command gets installed ODBC drivers with a name that begins with SQL Server on the 64-bit platform.


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

Example 4: Get all ODBC drivers

This command gets all installed ODBC drivers, and then stores them in the $driverArray variable for future use.


PS C:\> $driverArray = Get-OdbcDriver

Related topics

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft