Issues with pyodbc installation in venv python 3.10

See original GitHub issue

I have these environment and i would like to install pyodbc to work with accdb and mdb files.

  • Python: 3.10
  • OS: windows 10 64bit

I have created a virtual environment venv where i 'm trying to install the pyodbc as

python -m pip install pyodbc

Here it gives an error as:

Collecting pyodbc
  Using cached pyodbc-4.0.32.tar.gz (280 kB)
  Preparing metadata (setup.py) ... done
Using legacy 'setup.py install' for pyodbc, since package 'wheel' is not installed.
Installing collected packages: pyodbc
  Running setup.py install for pyodbc ... error
  error: subprocess-exited-with-error

  × Running setup.py install for pyodbc did not run successfully.
  │ exit code: 1
  ╰─> [5 lines of output]
      running install
      running build
      running build_ext
      building 'pyodbc' extension
      error: Microsoft Visual C++ 14.0 or greater is required. Get it with "Microsoft C++ Build Tools": https://visualstudio.microsoft.com/visual-cpp-build-tools/
      [end of output]

  note: This error originates from a subprocess, and is likely not a problem with pip.
error: legacy-install-failure

× Encountered error while trying to install package.
╰─> pyodbc

note: This is an issue with the package mentioned above, not pip.
hint: See above for output from the failure.

I have verified that MS Visual C++ is already installed and but it is still giving an error.

could you please help me out to solve this on priority ?

Issue Analytics

  • State:closed
  • Created 2 years ago
  • Comments:11 (1 by maintainers)

github_iconTop GitHub Comments

github_iconTop Results From Across the Web

unable to install pyodbc using python 3.10 in windows 10
That's the issue. There are no precompiled binaries (wheel files) for 3.10, at least not yet. So setup.py tries to build pyodbc from...
Read more >
Step 1: Configure pyodbc Python environment - Microsoft Learn
Go to the Python download page and download the appropriate installer. For example, if you are on a 64-bit machine, download the Python...
Read more >
Unable to install pyodbc on windows server - Python Help
I am unable to install pyodbc or eciespy using PIP install pyodbc. I get the following error: ERROR: Command errored out with exit...
Read more >
pyodbc - PyPI
pyodbc is an open source Python module that makes accessing ODBC databases simple. It implements the DB API 2.0 specification but is packed...
Read more >
New to PyCharm. I used PIP to install PYODBC ... - YouTrack
I used PIP to install PYODBC using command line and it works through Idle. ... C:\Users\dschild\PycharmProjects\DatabaseTest\venv\Scripts\python.exe ...
Read more >

github_iconTop Related Medium Post

No results found

github_iconTop Related StackOverflow Question

No results found

github_iconTroubleshoot Live Code

Lightrun enables developers to add logs, metrics and snapshots to live code - no restarts or redeploys required.
Start Free

github_iconTop Related Reddit Thread

No results found

github_iconTop Related Hackernoon Post

No results found

github_iconTop Related Tweet

No results found

github_iconTop Related Dev.to Post

No results found

github_iconTop Related Hashnode Post

No results found