To make that work, you need certain files alongside the PyODBC library, as @anderson-guse mentioned. For now, you can use the pre-built artifacts I've created, which are ready to use for Python 3.9 to 3.12. You can find them on my GitHub here.
Note: These artifacts currently support only the x86_64 architecture.