ibm_db error even though package is installed

[runnerpaul]

Hi,

I've installed ibm_db to project interpreter but when I run my script I get the following error:

Error:
/Library/Frameworks/Python.framework/Versions/3.4/bin/python3.4 /Users/paulcarron/Downloads/Python/billing_extraction/Main.py 2010-01-01 2020-01-01 Carron
Traceback (most recent call last):
  File "/Users/paulcarron/Downloads/Python/billing_extraction/Main.py", line 5, in <module>
    import ibm_db
ImportError: dlopen(/Library/Frameworks/Python.framework/Versions/3.4/lib/python3.4/site-packages/ibm_db.so, 2): Library not loaded: libdb2.dylib
  Referenced from: /Library/Frameworks/Python.framework/Versions/3.4/lib/python3.4/site-packages/ibm_db.so
  Reason: image not found

Process finished with exit code 1

Can anybody advise on the issue and ho to resolve it?

[Larz60+]

image not found ...
is that library supposed to contain, (or dependent on image(s))?

[runnerpaul]

Sorry, I'm not sure. Python is new to me.

[wavic]

See this or this or this. I hope you find a solution there.

[runnerpaul]

Thanks but I've already seen them.

I tried running it through Terminal and got the following:

Error:
Thanks but I've already seen them.

I tried running it through Terminal and got the following:
Python Main.py
Traceback (most recent call last):
  File "Main.py", line 5, in <module>
    import ibm_db
ImportError: dlopen(/Library/Python/2.7/site-packages/ibm_db-2.0.7-py2.7-macosx-10.12-intel.egg/ibm_db.so, 2): Library not loaded: libdb2.dylib
  Referenced from: /Library/Python/2.7/site-packages/ibm_db-2.0.7-py2.7-macosx-10.12-intel.egg/ibm_db.so
  Reason: unsafe use of relative rpath libdb2.dylib in /Library/Python/2.7/site-packages/ibm_db-2.0.7-py2.7-macosx-10.12-intel.egg/ibm_db.so with restricted binary

Does that shed any light on the reason?

---

Sorry, ignore that last post. I was executing with the wrong version of Python. I get the same error in terminal as when I execute the script in PyCharm:

Error:
Traceback (most recent call last):
  File "Main.py", line 5, in <module>
    import ibm_db
ImportError: dlopen(/Library/Frameworks/Python.framework/Versions/3.4/lib/python3.4/site-packages/ibm_db.so, 2): Library not loaded: libdb2.dylib
  Referenced from: /Library/Frameworks/Python.framework/Versions/3.4/lib/python3.4/site-packages/ibm_db.so
  Reason: image not found

[Larz60+]

Do you have a reason for using ibm_db?
I think if you don't already have code that uses DB2 or Informix you would be better off
choosing another RDBMS.
Very easy to install and use is sqlite3.
Not quite so easy to install, but i my opinion the very best of the open source RDBMS is
PostgreSQL (Especially if you plan on doing any GIS work).
And there are of course others, MySQL and more.
PostgreSQL is on par with Oracle, but it's free!

[runnerpaul]

Unfortunately yes. I have an application that uses the db and I want a similar setup to do some testing.