Closed GoogleCodeExporter closed 9 years ago
See http://code.google.com/p/ibm-db/issues/detail?id=113 for better diagnostic
of the error.
I had similar issue, and the cause was that ibm_db_django needs ibm_db.pyd
(what can be seen in apache error log), and pyd couldn't be loaded in apache
process - *n*x version because some db2 dll/.so was not in the path:
libdb2.so.1: cannot open shared object file: No such file or directory
Solution: setup path (win) or LD_LIBRARY_PATH on *n*x systems for apache
process on process start.
Reference:
http://code.google.com/p/modwsgi/wiki/InstallationIssues#Unable_To_Find_Python_S
hared_Library
Original comment by trebor74hr@gmail.com
on 14 May 2012 at 8:22
Hi, thanks for reply.
I use only ibm_db module (not ibm_db_django) to perform raw sql queries.
I try to get further information from exception doing
try:
import ibm_db
except Exception, e:
print e
and I have
DLL load failed: specified module not found
without missing dll name information
following PATH information set on windows environ
C:\Windows\system32;
C:\Windows;
C:\Windows\System32\Wbem;
C:\Windows\System32\WindowsPowerShell\v1.0\;
C:\PROGRA~1\IBM\SQLLIB\BIN;
C:\PROGRA~1\IBM\SQLLIB\FUNCTION;
C:\PROGRA~1\IBM\SQLLIB\SAMPLES\REPL;
c:\python27;
c:\python27\Scripts;
C:\PROGRA~1\IBM\SQLLIB\clidriver\bin;
C:\VEnvs\services\Scripts;
C:\Program Files\IBM\SQLLIB\lib;
C:\Program Files\IBM\SQLLIB\lib\Win32
Thanks for help
Original comment by marcoi...@gmail.com
on 15 May 2012 at 9:58
Django will not communicate directly with ibm_db, so please cross check for
ibm_db_django.
Please check your settings.py file and let us know what you have given in
'ENGINE' name.
Original comment by rahul.pr...@in.ibm.com
on 15 May 2012 at 10:19
Thanks for reply.
I don't understand why I need ibm_db_django.
Just for explain what i'm doing:
we need to perform raw sql queries to db2 database from a django application
used as webservice app.
we have no models defined into application
we perform only following type of statements:
conn=ibm_db.connect(...,...,...)
stmt = ibm_db.prepare(conn, sql)
ibm_db.bind_param(stmt, 1, param)
ibm_db.execute(stmt)
...
with runserver all works properly but with apache/mod_wsgi not.
Thanks
Original comment by marcoi...@gmail.com
on 15 May 2012 at 11:18
You are getting the above errors due to apache didn't able to find either
ibm_db.pyd or db2cli.dll file.
Please set the PATH variable in 'envvars' with 'C:\PROGRA~1\IBM\SQLLIB\BIN',
'c:\python27', and c:\python27\Scripts .
please let us know it works for you or not.
Original comment by rahul.pr...@in.ibm.com
on 16 May 2012 at 12:13
Hi
sorry for late.
Maybe the cause of the issue was that server had 64 bit architecture. Now I
have configured a windows 32 bit server with .NET framework 3.5 (I don't know
if is a requirements) and now work, without settings apache 'envvars' but only
setting PATH system variable.
Thanks
MI
Original comment by marcoi...@gmail.com
on 19 Jun 2012 at 2:35
Hello,
Please help!
I have ubuntu 12.04 64-bit (similar to your old configurations), and I am
unable to install ibm_db or ibm_db_django using easy_install. I managed to make
it work on windows, but on linux I get the error:
Environment variable IBM_DB_HOME is not set. Set it to your
DB2/IBM_Data_Server_Driver installation directory and retry ibm_db module
install.
Can you provide any feedback about that or how to fix this problem?
Thanks a lot!
Original comment by narmer1...@gmail.com
on 25 Aug 2012 at 8:24
Please set you IBM_DB_HOME environment variable to "/path/to/sqllib" or If you
are using IBM_Data_Server_Driver client then set it to DS Driver intallation
directory.
Original comment by rahul.pr...@in.ibm.com
on 26 Aug 2012 at 5:05
I experienced this problem on Windows. Check the following link:
http://stackoverflow.com/questions/3706293/why-do-no-python-dlls-built-with-msvc
-load-with-mod-wsgi
Original comment by cw...@trottertech.com
on 28 Aug 2012 at 5:29
Original comment by rahul.pr...@in.ibm.com
on 22 Oct 2012 at 6:05
Original issue reported on code.google.com by
marcoi...@gmail.com
on 14 May 2012 at 4:13