Python can't find pyobdc. Is the Folder name the issue?

Programming
,
1

I’m running 64-bit Windows 7 with Python 3.7 and having trouble importing pyodbc. After using pip install pyodbc, I find the package installed in C:\\Users\\Owner\\AppData\\Local\\Programs\\Python\\Python37\\Lib\\site-packages. The sys.path includes the necessary path, and pip uninstall pyodbc removes it without issue.

However, when I try to import pyodbc I get the following error:

ImportError: DLL load failed: the specified module could not be found

I’m wondering if the problem is due to the directory name, which is pyodbc-4.0.28.dist-info instead of pyodbc. Does anyone have any ideas on how to solve the issue?

2

You need to install the Microsoft ODBC Driver for SQL Server. You can download it from the Microsoft Download Center. Once you have installed the driver, try importing pyodbc again.