ibm_db install problem - Printable Version

ibm_db install problem - Printable Version

+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: General Coding Help (https://python-forum.io/forum-8.html)
+--- Thread: ibm_db install problem (/thread-38546.html)

ibm_db install problem - mesi1000 - Oct-27-2022

I have problem to install ibm_db on Windows Home 10
I managed to install it in Visual Studio with the info successfull instalation but when trying to debug there is problem like below:
------------------------------------------------------
Message=DLL load failed while importing ibm_db: The specified module could not be found.
Source=C:\Users\zdzis\source\repos\PythonApplication2\PythonApplication2\PythonApplication2.py
StackTrace:
File "C:\Users\zdzis\source\repos\PythonApplication2\PythonApplication2\PythonApplication2.py", line 1, in <module> (Current frame)
import ibm_db
--------------------------------------------------------
my sysytem env are:
IBM_DB_HOME=C:\DB2\IBM\SQLLIB
path=C:\Program Files\IBM\IBM DATA SERVER DRIVER
path=C:\DB2\IBM\SQLLIB\clidriver\bin

what can it be, don't you know guys ?

RE: ibm_db install problem - snippsat - Oct-27-2022

You most install the Python DBI driver for IBM Db2 | GitHub
This run from command line.

pip install ibm-db

Are you familiars with python and pip from command line?
Do this from cmd

C:\>python -V
Python 3.10.5

where python
C:\python310\python.exe

C:\>pip -V
pip 22.3 from C:\python310\lib\site-packages\pip (python 3.10)

Then in PythonApplication2.py add this as test(run only this).

import sys

print(sys.executable)

Output:
C:\Python310\python.exe

So here you see all point to same version,Visual Studio may install a own version of Python.
I think very few that use Python are use Visual Studio,a lot use VS Code which has better support for Python.