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

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?

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.