PowerShell Logo Small

Get-OdbcDriver



This is the built-in help made by Microsoft for the command 'Get-OdbcDriver', in PowerShell version 4 - as retrieved from Windows version 'Microsoft Windows 8.1 Enterprise' 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 n
ot 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 th
e 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.