InstallScript MSI Project: Error 1918: ODBC Driver not found due to system error code 126

InstallScript MSI Project: Error 1918: ODBC Driver not found due to system error code 126

Symptoms:

The following error message is displayed at runtime:

odbc.PNG

Cause:
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.

FileName.png

Workaround:

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.

Was this article helpful? Yes No
No ratings
Version history
Revision #:
4 of 4
Last update:
‎Feb 11, 2021 10:43 AM
Updated by: