InstallScript MSI Project: Error 1918: ODBC Driver not found due to system error code 126
The following error message is displayed at runtime:
The issue is happening due to the short filename in the FileName column that is added by design when a long filename is referenced in the project.
This issue can be resolved by installing the Microsoft ODBC Driver 17 for SQL Server as a prerequisite and changing the msodbcsql17.dll FileName from [MSODBC~1.DLL|msodbcsql17.dll] to [msodbcsql17.dll] in the File table of the Direct Editor.
Or by installing the MSI from here and removing the short filename from the File table in the Direct Editor.