0

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.

Alexandr Kapshuk
  • 1,380
  • 2
  • 13
  • 29

2 Answers2

1

You can try the following:

See whether the relevant mirror (or any) is available in your configuration by checking your mirror list in /etc/pacman.d/mirrorlist

Update your system with pacman -Syyu, then try again.

For more info, read https://wiki.archlinux.org/index.php/Mirrors

Edit: If this still doesn't work, please post the contents of your mirrorlist here.

Thomas
  • 4,696
  • 5
  • 36
  • 71
1

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.

sancho.s ReinstateMonicaCellio
  • 14,708
  • 20
  • 93
  • 185