I'm trying to use blpapi in python. Since my company has a strict firewall, I had to do an offline install of the latest one from condaforge ('blpapi-3.17.1-py38_blpapicpp3.16.1.1_1'). I've tried nearly every solution on stackoverflow including:
- Pasted the matching C++ SDK dll libraries for C++ 3.17.1.1 into the DAPI folder and anaconda site packages.
- Also pasted the dll files in system32 and tried running import blapi with os.add_dll_directory function.
- Added the bin and lib C++ SDK dll paths to the system environment PATH as well as in Spyder.
- Installed Visual Studio and the relevant C++ MFC, C++/CLI support, MSVC v143 tools etc.
---------------------------- ENVIRONMENT -----------------------------
Platform: Windows-10-10.0.19041-SP0
Architecture: ('64bit', 'WindowsPE')
Python: 3.8.5 (default, Sep 3 2020, 21:29:08) [MSC v.1916 64 bit (AMD64)]
Python implementation: CPython
This Python version does not use PATH to find dlls
blpapi package at: "C:\ProgramData\Anaconda3\lib\site-packages"
Current directory: "C:\blp\blpapi_cpp_3.17.1.1\lib"
----------------------------------------------------------------------
DLL load failed while importing _versionhelper: The specified module could not be found.
Could not open the C++ SDK library.
Download and install the latest C++ SDK from:
http://www.bloomberg.com/professional/api-library
If the C++ SDK is already installed, Python 3.8+ on Windows requires that the
path to the library is added to 'add_dll_directory', i.e.:
with os.add_dll_directory('<path to blpapi dlls>'):
import blpapi```