PowerShell Logo Small

Get-OdbcDriver



This is the built-in help made by Microsoft for the command 'Get-OdbcDriver', in PowerShell version 3 - as retrieved from Windows version 'Microsoft Windows Server 2012 Standard' PowerShell help files on 2016-06-23.

For PowerShell version 3 and up, where you have Update-Help, this command was run just before creating the web pages from the help files.

SYNOPSIS

Retrieves one or more installed ODBC drivers from the system that match the value passed to the Name parameter. If the Name parameter is not specified, retrieves all installed ODBC drivers from the system.

SYNTAX


Get-OdbcDriver [[-Name] <String>] [-AsJob [<SwitchParameter>]] [-CimSession <CimSession>] [-Platform <String>] [-ThrottleLimit <Int32>]
[<CommonParameters>]



Search powershellhelp.space

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.



<

RELATED LINKS

Set-OdbcDriver
N:Wdac



REMARKS

<

Examples




PS C:\> Get-OdbcDriver



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






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:






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:






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: