Python Bloomberg API ( 'DLL load failed' )

Question

My Python version is 2.7.3 and OS is Windows 7.

I want to use the Bloomberg API libraries. Specifically, 'importing error blpapi' is my most problem.

At this site, I've tried to run both Supported Release(v3.5.5) and Experimental Release(v3.5.3). But both are not work.

Writing import blpapi in IDLE, I keep getting an following error message:

Traceback (most recent call last):

File <pyshell#0>, line 1, in <module>

import blpapi

File C:\Python27\lib\site-packages\blpapi\__init__.py, line 5, in <module>

from .internals import CorrelationId

File C:\Python27\lib\site-packages\blpapi\internals.py, line 50, in <module>

_internals = swig_import_helper()

File C:\Python27\lib\site-packages\blpapi\internals.py, line 46, in swig_import_helper

_mod = imp.load_module('_internals', fp, pathname, description)

ImportError: dll load failed specified module could not found

How can I solve this problem? (I hope to import 'blpapi')

Answer 1

With reference to this: Python 2.7 with Bloomberg API import blpapi failure

The ImportError is the result of Bloomberg not being able to find the "blpapi3_32.dll" DLL file. This DLL file can be located under the \bin or \lib folder of Bloomberg's C/C++ library, which is at the same location where you got your Python executable. So go download that library (v3.7.5.1 as of this writing), and have your system's "Path" environment variable include that location. This should resolve the issue.

PS you can access the PATH variable via Start > right-clicking "Computer" > Properties > Advanced System Settings > Advanced (tab) > Environment Variables > look for the "Path" variable under "System variables". Edit this variable to include the location of the DLL file, e.g. if the original Path variable is "C:\Python27\Lib\site-packages\PyQt4", then new Path variable should be "C:\Python27\Lib\site-packages\PyQt4;C:\blp\API\blpapi_cpp_3.7.5.1\bin"