PowerTip: Use PowerShell to Find ODBC Drivers


Summary: Use Windows PowerShell to find installed ODBC drivers.

Hey, Scripting Guy! Question How can  I use Windows PowerShell to check installed ODBC drivers so that I can investigate if a missing
           driver might be the cause of a database application that appears to be failing?

Hey, Scripting Guy! Answer Use the Get-OdbcDriver function from the WDAC module, for example:

Get-OdbcDriver | Format-Table name, platform -AutoSize

Comments (1)

  1. Ross says:

    Special steps to use odbc in a 64bit environment to connect to an Access database in Office 32bit.

    In my instance Windows 7 Professional 64 bit, Office 2013 Professional 32bit & PSVersion 4.0

    You must use the 32 bit version of PowerShell. This is located in Start –> All Programs –> Accessories –> Windows PowerShell –> Windows PowerShell (x86)

    code start ————————

    Add-Type -AssemblyName system.data

    $conn = New-Object System.Data.Odbc.OdbcConnection

    ‘# Then follow standard connection string and connection.open commands.
    # Recommend this site for connection strings;
    https://www.connectionstrings.com/access/

    code end ———————–

    Troubleshooting; this method relies on the presence of
    C:Program Files (x86)Common Filesmicrosoft sharedOFFICE141033ACEODBCI.DLL

Skip to main content