python调用ibm_db连接库报错UnicodeDecodeError: 'ascii'

win下调用DB2库，报错，代码如下：

1. # -*- coding: utf-8 -*-
   
2. import ibm_db
   
3. import sys
   
4. import imp
   
5. imp.reload(sys)
   
6. 
   
7. 
   
8. class myDB2():
   
9.     try:
   
10.         conn_str = 'DATABASE=TEST;HOSTNAME=192.168.43.52;PORT=50000;PROTOCOL=TCPIP;UID=user;PWD=user;'
    
11.         conn = ibm_db.connect(conn_str, '', '')
    
12.     except:
    
13.         print("no connection:", ibm_db.conn_errormsg())
    
14.     else:
    
15.         print("The connection was successful")
    
16. 
    
17.     sql = "select * from subsys_pvt_cfg"
    
18.     stmt = ibm_db.exec_immediate(conn, sql)
    
19.     result = ibm_db.fetch_tuple(stmt)
    
20.     while result:
    
21.         #print(result[0], result[1])
    
22.         result = ibm_db.fetch_tuple(stmt)
    
23. 
    
24. 
    
25. # --------------------------------------------------
    
26. if __name__ == '__main__':  # 如果整个程序是主程序
    
27.     myDB2()
    

复制代码

----------------------------------------------------------------------------------
报错如下：
PS E:\my_program\python\vscode> & "D:/Program Files/python/python.exe" e:/my_program/python/vscode/pyqtTest/db2test.py
Traceback (most recent call last):
  File "e:/my_program/python/vscode/pyqtTest/db2test.py", line 12, in myDB2
Exception
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
  File "e:/my_program/python/vscode/pyqtTest/db2test.py", line 9, in <module>
  File "e:/my_program/python/vscode/pyqtTest/db2test.py", line 14, in myDB2
UnicodeDecodeError: 'ascii' codec can't decode byte 0xbc in position 29: ordinal not in range(128)