pip install pyodbc is not working on python

Question

I installed Python on my Windows 10 computer

when I try to run my python code

I get error

ModuleNotFoundError: No module named 'pyodbc'

I checked multiple questions here and the solution is to pip pyodbc

I tried that

pip install pyodbc

but i get error

SyntaxError: invalid syntax

I checked similar propblems here and it seems that pip is not installed.

I unistalled and reinstalled python from python.org and still same issue!

any solution?

Edit

I did as suggested to try from command prompt

but still same error

I installed Python with ticking the option to include environment variables option.

Edit 2 :

I think the problem was that I was trying to install from witthin python.

I misunderstood the answers, I have to run pip as an application outside of python. to allocate pop.exe and then do pip install.

You have to run `pip install pyobdc` in the command prompt. That's the Python shell, and that's invalid Python code. — Dock, Jan 03 '21 at 16:24
@asmgx your confusion is understandable. Too many into to Python tutorials don't take the time to explain home paths and interpreters work. — Zerodf, Jan 03 '21 at 18:34

score 4 · Answer 1 · answered Jan 03 '21 at 16:22

4

You would run pip from a shell, not from the IDLE. However, pyodbc requires the Microsoft ODBC Driver. More information about installing the pyodbc module can be seen in this guide. This Stack Overflow answer can also help.

answered Jan 03 '21 at 16:22

DapperDuck

2,728
1
9
21

I did as suggested to try from command prompt but still same error – asmgx Jan 03 '21 at 16:33

score 3 · Answer 2 · answered Jan 03 '21 at 16:18

3

You are trying to install the package from python interpreter (IDLE) which is wrong. You should only import package from IDLE terminal (python session) which IDLE has access to.

Try this link to install the package --> https://pip.pypa.io/en/latest/installing/

answered Jan 03 '21 at 16:18

gsb22

2,112
2
10
25

I did as suggested to try from command prompt but still same error – asmgx Jan 03 '21 at 16:33

score 2 · Accepted Answer · answered Jan 03 '21 at 16:16

2

Normally, you run pip from a shell, not from a Python interactive session.

C:\PATHTOPYTHON\python.exe pip install <<SOMEPACKAGE>>

See the following thread, if you want to install from within a Python interactive session.

answered Jan 03 '21 at 16:16

Zerodf

2,208
18
26

I did as suggested to try from command prompt but still same error – asmgx Jan 03 '21 at 16:33
python.exe: can't open file 'C:\Program Files\Python39\pip': [Errno 2] No such file or directory – asmgx Jan 03 '21 at 16:35
@asmgx if you start a cmd.exe shell, and type "where python," what comes up? – Zerodf Jan 03 '21 at 18:33

pip install pyodbc is not working on python

3 Answers3