So after a couple of hours, I managed to solve the problem. I did several
things and still unsure what was the actuall fix, but this is the step-by-step
flow I’ve done:
- Created a new environment using Anaconda. I’ve downgraded the Python version to 3.6.8, since I saw mentions of several compatibility problems with Python 3.7
- Installed all the requirements from my project, using Anaconda, since some mention problems due to mixed usage of
pip
andconda
. - Installed the latest version of
pyinstaller
. - Activated the new environment and run
pyinstaller
from within it on themain.py
script of the program with--hidden-import pyodbc
argument.
That’s it, now the distibuted program works on all Windows computers in the
office.



