mportError: DLL load failed:

[jarthda]

Windows 7 Anaconda3 4.3.1

I've developed a script to insert files to into SQL. It worked fine for weeks and now I get the following: 



  File "DirectorySweeper3.1.py", line 2, in <module>
    import pyodbc
ImportError: DLL load failed: The specified procedure could not be found.


I've research and found nothing helpful (although I'm not the savvy) What I did do:

1) Set the path environment variable to Lib,libs,libaray,DLLs
2) reinstalled pyodbc
3) reinstall anaconda3

My only theory on what changed would be an automatic update pushed from our IT department.

[Larz60+]

You need to post runable code

[nilamo]

Have you tried reinstalling the odbc drivers? It wouldn't be a python package...

[jarthda]

I'll try to reinstall ODBC drivers. I would post runnable code, but it won't run! 2nd line kills it

import os
import pyodbc  < ------ Oucch!!!!
import codecs
import datetime
import sys
import time
import math

---

I tried to reinstall ODBC driver from microsoft. No luck.

---

I've also tried to reinstall C++ run-time libraries. Still no luck.

[jarthda]

It's amazing how little there is on this error. Can anyone think of a workaround? Another module? How would one look deeper into this problem?

[snippsat]

Have you tried with wheel.
Quick test with virtual environment that i use for a lot stuff.

E:\1py_div
λ python -m venv pyodbc_test
E:\1py_div
λ cd pyodbc_test
E:\1py_div\pyodbc_test
λ E:\1py_div\pyodbc_test\Scripts\activate.bat
(pyodbc_test) E:\1py_div\pyodbc_test
λ pip install pyodbc-4.0.16-cp36-cp36m-win32.whl
Processing e:\1py_div\pyodbc_test\pyodbc-4.0.16-cp36-cp36m-win32.whl
Installing collected packages: pyodbc
Successfully installed pyodbc-4.0.16

(pyodbc_test) E:\1py_div\pyodbc_test
λ python
Python 3.6.1 (v3.6.1:69c0db5, Mar 21 2017, 17:54:52) [MSC v.1900 32 bit (Intel)] on win32
Type "help", "copyright", "credits" or "license" for more information.
>>> import pyodbc
>>> pyodbc.version
'4.0.16'
>>>

[jarthda]

Thanks snipsatt, I'll look into this. I know not what it is but I would like another troubleshooting tool.

---

I ran this test. Pretty neat. It worked perfect. Looked like it installed, imported and reported the version. So this works but I still get he DLL error. How to proceed?

[jarthda]

I resloved this by uninstalling pyodbc with conda-install and installing with pip. I have no idea why it makes a different but I'm up and running

[nilamo]

Sounds like conda doesn't have all the dependencies set, then.