My script calls:
...but returns error:
Traceback (most recent call last): File "C:\MyPyScripts\extract.py", line 1, in <module> import pyodbc ImportError: No module named pyodbc Failed to execute (extract).
I'm overwhelmed and confused by everything I've read on how to install this particular python module I'm trying to use in ArcGIS 10.5.
My machine is a Windows 10, just upgraded to ArcGIS 10.5.1 (from 10.3.1) and I also have ArcGIS Pro installed. I'm trying to get my work done in 10.5.1 (not really using ArcGIS Pro for much of anything yet).
My head is swirling with variations in the python between Map and Pro. Do I have to use "PIP"? (When I try running
pip install pyodbc from the cmd as administrator, it says that pip is not recognized as an external command).
My questions are:
- Assuming a typical ArcGIS 10.5 installation, as well as ArcGIS Pro, what python-related files/directories/runtimes/libraries would I most likely currently have installed by default? PIP?
- What prerequisites is a user like me likely to need before installing a module like pyodbc?
- Do I need to do something to install PIP? Or, is that only used/needed for Pro? Can I somehow install the pyodbc module without PIP?