pyodbc module not found

user_5649739 0
Viewed 3859

I am facing a situation where modules like pyodbc which used to work earlier (3 weeks back) are not working anymore in my laptop. I am repeatedly getting Module not found error.

To resolve it by myself, I have gone through similar articles in stack overflow and implemented some suggestions like this. Yet the issue still persists. My machine (Windows 10) has only one python version (python v3.7.2), and I have never created any virtualenv. 

C:\Users\Kris\eclipse-workspace\SQLPyODBC>conntest.py --serverName "IDEA-PC\SQLEXPRESS" --name "SampleStore" --trustedConn "yes"
Traceback (most recent call last):
  File "C:\Users\Kris\eclipse-workspace\SQLPyODBC\conntest.py", line 1, in <module>
    import pyodbc
ModuleNotFoundError: No module named 'pyodbc'

The referenced package is available under C:\Users\Kris\AppData\Local\Programs\Python\Python37-32\Lib\site-packages directory. Also the path of python interpreter in eclipse IDE (PyDev) is pointing to correct python executable path.

Just to test, I have downloaded pymssql module, and guess what... it is also showing the same error message. I have uninstalled and re-installed packages. No solution.

importerror pyodbc python-3.x python-import python
2 Answers

If you're using Anaconda install using following code,

conda install -c anaconda pyodbc
user_172418460

Before importing pyodbc in python, you should install the module by using pip directly from cmd.

pip install pyodbc

if that does not work, try using pip to uninstall and install it again after a restart (Or kill all python related tasks). Hope it works

user_113748480
Related