I installed the Db2 ODBC driver in Windows 10 following these instructions. I extracted the driver folder in C:oolsdb2cli
and run db2cli install -setup
from the bin
folder.
This seems to have worked fine, as the ODBC driver was registered in Windows:
But when I try to connect from Jupyter
I get this error:
server = 'localhost'
database = 'mydb'
username = 'db2inst1'
password = 'abc123'
driver = 'IBM DB2 ODBC DRIVER - C_tools_db2cli'
conn = pyodbc.connect('DRIVER={' + driver +'};SERVER='
+ server + ';DATABASE=' + database + ';UID='
+ username + ';PWD=' + password + ';PROTOCOL=TCPIP;PORT=50000' )
Error Traceback (most recent call
last) in
4 password = 'abc123'
5 driver = 'IBM DB2 ODBC DRIVER - C_tools_db2cli'
----> 6 conn = pyodbc.connect('DRIVER={' + driver +'};SERVER='
7 + server + ';DATABASE=' + database + ';UID='
8 + username + ';PWD=' + password + ';PROTOCOL=TCPIP;PORT=50000' )
Error: ('HY000', '[HY000] [IBM][CLI Driver] SQL1042C An unexpected
system error occurred. SQLSTATE=58004
(-1042) (SQLDriverConnect);
[HY000] [IBM][CLI Driver] SQL1042C An unexpected system error
occurred. SQLSTATE=58004
(-1042)')
I unsuccessfully tried to find the error codes to find a solution. What should be looked at to fix this problem?
Note: I added C:oolsdb2cliin
to the PATH but still get the same error.
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…