I want to install the pyodbc (or pymssql or turbodcb) package for the MSYS2 Python installation, but I can't figure how I can download it. On my regular Python instance, I'm using pip install pyodbc. On the MSYS2 instance, I'm trying pacman -S mingw-w64-x86_64-python3-pyodbc but I'm getting target not found error.
How can I download the package?
I need pyodbc to run pandas.read_sql statement. So if there is any other package downloadable with pacman that creates connection that pandas.read_sql may use, that'll work.
After googling a little bit, and as per
$ pacman -Ss pyodbc
(see this) there seems to be no pyodbc package available for pacman.
Check also this online search tool.
You have the alternative pip way, but the package manager would lose track of what is going on.
You may try a virtualenv to overcome this hurdle, but I have seen many complaints about virtualenv not working in msys2.
I never tried it myself.
This may be relevant.