Exporting a list of ODBC Datasource drivers?

Question

Is it possible to export a CSV file of the list of database driver names from the Create New Data Source of the ODBC Data Source Administrator?

Answer 1

Does this article correctly describes how frustrated you feel? Obviously there is no easy way of getting this info... unless you consider upgrade to win 8 an easy way :-(

I used information in this article to make a powershell equivalent for you (you're on win 7 so ps v2 is installed by default):

get-itemproperty -path hklm:\software\odbc\odbcinst.ini\"Odbc drivers" |
get-member | 
where {$_.definition -match "installed"} |
select-object name | export-csv -noTypeInformation

Fire up powershell and paste above (you may need to press Enter key once or twice afer you paste). It will then ask you to give path - this is a path and file your data will be exported to (eg. c:\temp\myDrivers.csv) - press Enter - and if everything went well a file with driver list will be produced for you.

Edit: this will give additionally version and dll used.

get-itemproperty -path hklm:\software\odbc\odbcinst.ini\"Odbc drivers" |
get-member |
where {$_.definition -match "installed"} |
foreach-object { get-itemproperty -path $("hklm:\software\odbc\odbcinst.ini\"+ $_.name)} |
select-object PSChildName,Driver|Add-member -MemberType ScriptProperty -Name FVersion -Value {(((get-item $this.Driver).versionInfo)).FileVersion} -PassThru |export-CSV -noTypeInformation