Installing pyodbc for Python 3.7 on Windows

Question

I am a newbie to python and I need to connect to SQL Server. I run the following command in my DB_Connect.py file. I run python DB_Connect.py from CMD line and it gives error on import pyodbc.

Pic of error

I then I ran command pip install pyodbc but it give an error saying, "Microsoft Visual C++ 14.0 is required". I installed "Microsoft Visual C++ 2015 Redistributable" to accommodate this because I would need to get a license for a full version. My understanding is that this will work. I still get this error:

Pic of pip install pyodbc err

Do I need to install a full version of Visual C++ or is there a free option? Why doesnt this CMD work with the Redistributable version? How do I get past this step?

PC: windows 7 pro - 64 Python Version: 3.7.0

Why downwoting this. I'm a long time pyodbc user and this is an important issue. Creating the wheels should be a nightly build. — MortenB, Jul 10 '18 at 08:16

Gord Thompson · Accepted Answer · 2018-09-06T15:29:29.010

7

Update 2018-08-15

pyodbc 4.0.24, released today, now includes Python 3.7 wheels for installing on Windows and Mac via pip.

(original answer)

pyodbc wheel files for Python 3.7 are not yet available on PyPI. They have been requested via the GitHub issue here.

You could always revert to Python 3.6 for the time being. Or, if you really need Python 3.7 right now then you'll have to install the required Visual Studio components so pip can build pyodbc from source. Details here.

I then I ran command pip install pyodbc but it give an error saying, "Microsoft Visual C++ 14.0 is required". I installed "Microsoft Visual C++ 2015 Redistributable" to accommodate this

That didn't work because you installed the runtime support for Visual C++. You need the build tools for Visual C++, described here.

edited Sep 06 '18 at 15:29

answered Jun 29 '18 at 22:06

Gord Thompson

116,920
32
215
418

I just got back into town and thanks for the suggestion, everything worked out as expected. – jujulalu Jul 10 '18 at 16:27
1

@jujulalu: if it helped you can [accept the answer](https://stackoverflow.com/help/someone-answers) – Azat Ibrakov Jul 27 '18 at 12:48

score 0 · Answer 2 · edited Apr 20 '20 at 08:37

0

This solution worked for me:

pip install --only-binary :all: pyodbc

More about above: Microsoft Visual C++ 14.0 is required (Unable to find vcvarsall.bat)

edited Apr 20 '20 at 08:37

4b0

21,981
30
95
142

answered Apr 20 '20 at 08:22

Aleksander

1

Installing pyodbc for Python 3.7 on Windows

2 Answers2