title: Pyhdbcli SAP HANA Connection DLL Load Fail
body: <p>Long time lurker hoping to get some assistance with connecting Python to SAP HANA.</p>
  
  <p>I previously had it working perfectly however I recently wiped my Anaconda install to get a clean slate (start up performance issues with Jupyter) and now I can't get it to work at all!</p>
  
  <p>When I try and run the connection via sqlalchemy I get the following traceback:</p>
  
  <pre><code>~\AppData\Local\Continuum\anaconda3\lib\site-packages\hdbcli\dbapi.py in &lt;module&gt;()
  
  10 import sys
  
  11
  
  ---&gt; 12 import pyhdbcli
  
  13 from .resultrow import ResultRow
  
  14 
  
  ImportError: DLL load failed: The specified module could not be found.
  </code></pre>
  
  <hr>
  
  <p>I have tried to follow the tutorial below (copy the 5 files into the python Lib folder)...
  <a href="http://www.saphanacentral.com/p/power-of-python-integrated-with-sap-hana.html" rel="nofollow noreferrer">http://www.saphanacentral.com/p/power-of-python-integrated-with-sap-hana.html</a></p>
  
  <p>However I don't seem to even have a Python folder under C:\Program Files\sap\hdbclient as they have suggested in the tutorial</p>
  
  <p>Therefore I assumed that I should put it in with the rest of my Python packages under C:\Users\myname\AppData\Local\Continuum\anaconda3\Lib</p>
  
  <p>So far without any success.</p>
  
  <p>I would really appreciate any suggestions!
  Thanks!</p>