PowerShell Logo Small

Get-OdbcDriver



This is the built-in help made by Microsoft for the command 'Get-OdbcDriver', in PowerShell version 5 - as retrieved from Windows version 'Microsoft Windows Server 2012 R2 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

Gets installed ODBC drivers.

SYNTAX


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



Search powershellhelp.space

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.



<

RELATED LINKS

Online Version: http://go.microsoft.com/fwlink/p/?linkid=287605
Set-OdbcDriver
N:Wdac



REMARKS

<

Examples


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 with a name that begins 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.