Closed zobac closed 1 year ago
The FH4 option appeared only in VS 2019.
https://github.com/mkleehammer/pyodbc/blob/master/setup.py#L179
Looks like the option should only be added if the compiler version is new enough.
If you are having difficulty getting pyodbc to install from source on Windows you could try one of these unofficial wheels:
(Files removed. See below.)
AppVeyor deployed new Windows images with Python 3.11 support, see https://github.com/appveyor/ci/issues/3844. Therefore, it is in principle possible to use it to build win wheels for pyodbc (py3.11)
@SimoneD89 - #1115
The unofficial wheels given by GordThompson above cause an issue with creating sqlalchemy engines. sqlalchemy assumes that the version scheme is all integers, but the above version is 4.0.dev0, and so when creating an engine with sqlalchemy you get ValueError: invalid literal for int() with base 10: ''
from where the regex fails to pull the third element from the version and so tries int('')
Yes @scotscotmcc , those wheels should not be labelled 4.0.dev0, even if they are unofficial. I'm working on a fix, shouldn't take too long. Watch this space.
Hopefully, PR #1121 should fix this. It may be possible for you to download the artifacts from the CI pipeline (look for the file called "wheels"). That zip file should contain installable Windows wheels.
@keitherskine, the wheel in that download you have above appears to work just fine. Thanks a bunch!
Thanks to an amazing job by @keitherskine, new releases build official wheels now. There is an official 4.0.35 wheel available.
Please first make sure you have looked at: OS: Windows 10 64 bit Python: 3.11.0