Thursday, June 11, 2015

#85 : Find ODBC Drivers installed on the host with Powershell

ODBC Drivers are generally installed on servers to allow communication with different database engines. You can use Powershell to get the list of ODBC drivers installed on the host.
You need to run Get-ODBCDriver cmdlet which will give you all the details.

Get-OdbcDriver

Name      : Microsoft Access-Treiber (*.mdb)
Platform  : 32-bit
Attribute : {Driver, APILevel, FileExtns, FileUsage...}
Name      : Driver do Microsoft Paradox (*.db )
Platform  : 32-bit
Attribute : {Driver, APILevel, FileExtns, FileUsage...}
Name      : Driver do Microsoft Excel(*.xls)
Platform  : 32-bit

...

The output might not be pleasant. If you think so, you can try the line below:
Get-OdbcDriver | ft Name

Name                                                                                                                                                                      
----                                                                                                                                                                      
Microsoft Access-Treiber (*.mdb)                                                                                                                                          
Driver do Microsoft Paradox (*.db )                                                                                                                                       
Driver do Microsoft Excel(*.xls)                                                                                                                                          
Microsoft Text Driver (*.txt; *.csv)                                                                                                                                      
Driver da Microsoft para arquivos texto (*.txt; *.csv)                                                                                                                    
....

Thanks for reading!

 

No comments:

Post a Comment

#112: How to handle xml document in Powershell?

 In PowerShell, you can handle XML data using various cmdlets and methods provided by the .NET Framework. Here's a basic guide on how to...