Search code examples
visual-studio-2017windows-installerodbc

how to fix this issue: version "not marked" showing in "Driver" tab of ODBC Data source administrator


I have created MSI installer for an ODBC driver using Visual studio Installer in 2017(it was earlier created in 2010). I am able to successfully install driver, create registry entries as part of the installation but in the "Driver" tab of ODBC Data Source its show "Not Marked" for version and company. BUt in control panel, it does show version and company name. I have tried with manually registry entries, but not worked for me. I am an administrator user, so no question of permission arise.


Solution

  • Summary: The driver file must have proper version information. Ensure the version is there for the file as appropriate, in this case by using a VERSIONINFO resource added via a resource file (.rc).


    ODBCCONF.EXE: The tool ODBCCONF.EXE can apparently be used to register ODBC drivers (sample). By the way, do your drivers files have proper Product Version and File Version? (as in the files themselves, go to file properties). Not sure if that is important or not.

    PowerShell cmdlets: It appears the ODBCCONF.EXE tool is being removed from Windows soon (from Windows Data Access Components). It will be replaced by PowerShell CmdLets: Windows Data Access Components (Windows DAC) cmdlets.


    Registry Locations: Just for the record, there are several registry locations:

    • 64-Bit: HKEY_LOCAL_MACHINE\SOFTWARE\ODBC
    • 32-Bit: HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\ODBC

    Some Links: